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 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. 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 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