Question: Using MYSTORE DATABASE 1. Write a query to display the first name, last name, job, and Country for all Customers Who live in the
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)
Step by Step Solution
3.51 Rating (148 Votes )
There are 3 Steps involved in it
First of all student your question seems incomplete tables and attributes are ... View full answer
Get step-by-step solutions from verified subject matter experts
