Question: ISDS 3110: Data and Information Management LAB #2: Basic SQL Use the tables: customers, orders, and payments in the classicmodels schema to create queries to
ISDS 3110: Data and Information Management LAB #2: Basic SQL Use the tables: customers, orders, and payments in the classicmodels schema to create queries to answer the following questions/taks. Submit your 10 queries in one single.sql script. NOTE: Please make sure your code is correct and executable. Non-executable code will receive 0 I points 1. Report the sales representative number for each customer name. 2. Show the customer's name and credit limit for those credit limit is less than $50,000 3. Report the customer's name, customer's number, and phone number who lives in San Francisco. 4. Report the order numbers that have not been shipped (hint, is the operation for "not equal to."). 5. What is the total amount paid by all customers, in total? 6. How many orders have been placed by customer number 124? 7. Report those payments greater than $100,000 or less than $2,000, ordered by amount from highest to lowest. 8. Report those payments greater than $100,000, ordered by customer number. 9. List all customers containing Network' in their name, 10. List all customers whose data of state is missing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
