Nov 23, 2024
HEP 456 Module 5 Section 12 and 13 Planning for Analysis and Interpretation and Gantt chartĀ
HEP 456 Module 5 Section 12 and 13 Planning for Analysis and Interpretation and Gantt chartĀ Name HEP 456: ā¦
Unit 8 Assignment 1
Unit 8 Assignment
Kaplan University
IT234 Database Concepts
ā¢Use SQL statements to fetch data from more than one table.
Create a report of each product, showing productID, ProductName, and CategoryName.
ā¢Use SQL subselect statement.
Create a report of the Last OrderID and the OrderDate for last order that was shipped to Cork.
Us
e SQL join statement.
Create a report that shows orders per customer, display OrderID, OrderDate, and
CustomerName.
Use SQL union.
Create a report that show all the CompanyNames from London, Madrid, and Lisboa in one result.
