Selecting Data Assignment - Database management (SQL)

ORDERTBL2EMPLOYEE1

CUSTOMER1

names of tables are next to images

Questions - 2 pts. each 1. What are the Customers First and Last Names? a. TIP This will be a select statement from the Customer table and instead of returning all columns, we just want the First and Last Names. 2. Which customer number has the highest Balance? 3. Which customer number has the lowest Balance? 4. How many orders has Landi Santos taken? (I'd like a count of the rows returned) 5. Using the same question as #4, what were the order numbers? (hint: select the order numbers, not a count) 6. Write a query that will return back the Customer First and Last Name along with the Employee First and Last Name if an Employee helped them with the Order? (I am looking for EVERY order, and if an order had an employee, also print the employee information. Hint: you will need an outer join somewhere) 7. Which order numbers have no Employee associated with them? 8. Listing the First and Last name of the customer, how many orders did they make? (hint: you will need count and a group by) 9. Return the name and email address of the Employee(s) who have not helped with an order. 10. Using the OrderTbl, determine the count of orders by date to determine which date had the most orders. EMPNO E8544399 E1329594 nm non ORDNO ORDDATE CUSTNO 1116324 01/23/2013 C0954327 2334661 01/14/2013 C0954327 3331222 01/13/2013 C1010398 2233457 01/12/2013 C2388597 4714645 01/11/2013 02388597 5511365 01/22/2013 03340959 7989497 01/16/2013 03499503 1656777 02/11/2013 C8543321 7959898 02/19/2013 C8543321 (null) E9884325 E1329594 E9884325 E9345771 (null) E9544399 AME I ... EMPNO EMPFIRSTNAME EMPLASTNAME_1 1 E8544399 Joe Jenkins 2 E8843211 Amy ... Tang 3 E9345771 Colin White 4 E9884325 Thomas ... Johnson 5 E9954302 Mary ... Hill 6 E1329594 Landi .... Santos ... ... EMPPHONE (303)221-9875 (303)556-4321 (303)221-4453 (303)556-9987 (303)556-9872 (303)7891234 EMPEMAIL JJenkins@bigco.com ATang@bigco.com CWhite@bigco.com TJohnson@bigco.com MHill@bigco.com LSantos@bigco.com 0 CUSTBAL 230 200 $CUSTNO CUSTFIRSTNAME CUSTLASTNAME CUSTCITY CUSTSTATE 1 C0954327 Sheri .... Gordon ... Littleton... CO 2 C1010398 Jim ... Glussman ... Denver ... CO 3 C2388597 Beth ... Taylor ... Seattle ... WA 4 C3340959 Betty ... Wise ... Seattle ... WA 5 03499503 Bob ... Mann ... Monroe ... WA 6 C8543321 Ron .... Thompson .... Renton ... WA CUSTZIP 80129-5543 80111-0033 98103-1121 98178-3311 980131095 98666-1289 ... ... ... ... ... ... 500 200