Using MYSTORE DATABASE 1. Write a query to display the first name, last name, job, and...

 

Transcribed Image Text:

Using MYSTORE DATABASE 1. Write a query to display the first name, last name, job, and Country for all Customers Who live in the US and their Credit limit is between $0 to $20,000 2. Write a query to show the orders whose total amount is greater than $60000 3. Write a query to display the list of orders that were disputed or cancelled in 2004 and 2005 4. How many employees have first name that ends with the letter 'd'(show query) s. What is the total quantity of classic cars in stock (show query) Using MYSTORE DATABASE 1. Write a query to display the first name, last name, job, and Country for all Customers Who live in the US and their Credit limit is between $0 to $20,000 2. Write a query to show the orders whose total amount is greater than $60000 3. Write a query to display the list of orders that were disputed or cancelled in 2004 and 2005 4. How many employees have first name that ends with the letter 'd'(show query) s. What is the total quantity of classic cars in stock (show query)

Answer rating: 100% (QA)

First of all student your question seems incomplete tables and attributes are ... View the full answer