Really need help with SQL Does the code look right based on the questions? 1. Populate each table with 10 entries. (Check that the data is realistic) /* Query populates 10 entries from each table */ SELECT * FROM CUSTOMER_t, VEHICLE_t, PARTS_t, SERVICE_TICKET_t, TECHNICIAN_t, INVOICE_t limit 10 SELECT * FROM CUSTOMER_t limit 10 SELECT * FROM VEHICLE_t limit 10 SELECT * FROM PARTS_t limit 10 SELECT * FROM SERVICE_TICKET_t limit 10 SELECT * FROM TECHNICIAN_t limit 10 SELECT * FROM INVOICE_t limit 10 2. Write a query that selects several entries in a table based on a particular attribute or set of attributes. /* Query based on particular attribute */ SELECT First_Name FROM CUSTOMER_t WHERE CUSTOMER_t.Insurance_Company in (‘All State’) GROUP BY First_Name 3. Write a query that joins data from two or more tables and outputs that data /* Query that joins data from two tables */ SELECT SERVICE_TICKET_t.Ticket_ID, CUSTOMER_t.First_Name, SERVICE_Ticket_t.DATE_RECEIVED FROM SERVICE_TICKET_t INNER JOIN CUSTOMER_t ON SERVICE_TICKET_t.Customer_ID=CUSTOMER_t.Customer_ID; 4. Delete or change an entry from a table based on a particular attribute or set of attributes. (Comment this code carefully) /* Deleting entry from table on given attribute */ DELETE FROM CUSTOMER_t WHERE First_Name=‘Tony Mao’;
newbie69 · Jun 21, 2017 6:49 PM · 6,832 views
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion