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
- Entity-relationship model, sql commands, Campus IST210 Lab