This preview shows page 1. Sign up to view the full content.
Unformatted text preview: sorted in descending order by the total field . 4. Display customer names containing the letters AND from the demo.customer table. The AND can appear anywhere within the name. 5. Sum up the field total in the item file for order_id 503. 6. Display the minimum salary, maximum salary, and number of employees assigned to department_id 30 in the table demo_employee . Be sure to review the Entity Relationship Diagram (ERD) for the DEMO database provided in the Lab # 4 folder in Angel. Please capture the SQL commands and the execution of the SQL commands in a Microsoft Word document by using the copy and paste feature of windows. Submit the Word document to the Angel web space for this class into the drop box for Lab # 4....
View Full Document
- Summer '08