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)
Sample Solution
