Show everything in the customer table.
First select the database bank. Answer the following questions using SQL query codes. After each question, provide your SQL query. You can submir a Word file, pdf file. Make sure you include the question number for each SQL query.Attached document is an example for you to follow
- Show everything in the customer table. (1pt)
- Show the first and last name of all customers. (1pt)
- Show all the DIFFERENT nationalities of the customers. (1pt)
- Show the names (first and last name) of the customers and their annual income. Sort the results in descending order by income. (1pt)
- Show all the customers (first and last name) whose last name is Barrows. (1pt)
- Show all the customers (first and last name) whose nationality is NOT Japan. (1pt)
- Show all the customers (first and last name) whose birth year is between 1970 and 1980. (1pt)
- Show the customers (first and last name) whose household size is greater than or equal to 6. (1pt)
- Show the customers (first and last name) whose email address ends with “com”. (1pt)
- Show the customers (first and last name) whose language is EITHER Chinese (cn), French (fr), English (en) OR Italian (it). (1pt)
- Show the customers (first and last name) from California (CA) that have annual income greater than $200,000. (2pt)
- Show customers (first and last name) that are born after (>) 1990 or have annual income less than $20,000. (2pt)
- Show the customers (first and last name) whose birth year is NOT between 1950 and 1990. (2pt)
- Show the customers (first and last name) that are from Texas(TX), Florida(FL), Indiana(IN) or Oregon(OR), AND has household size of less than 4. (2pt)
- Show the customers (first and last name) whose zipcode starts with 0, and are born after 1950. Sort the results in descending order by birth year. (2pt)
