Information Technology > STUDY GUIDE > Group Assessment - Template - SQL Queries & Output - Fanshawe College IT 8060 (All)

Group Assessment - Template - SQL Queries & Output - Fanshawe College IT 8060

Document Content and Description Below

Group Assessment #1 SQL Queries & Output PROG8650 – SECTION #2 KHEDEKAR, GAURI SANJAY;MALEK, MOHAMMEDZAID,MOHAMMEDYUSUF;MANIK, ANKUSH;MOHAMMED, YAQOOB ATIF;RAI, ANURAG KUMAR) DATE 5/31/20222 ... CONESTOGA COLLEGE – PROGRAM 1372 Group-8 Group Assessment #1 PROG8650 – SECTION #2 ************************************************************************************************** Question #1: Within the PRODUCT schema, show all records from the Product.Category table. SQL Query SELECT * FROM Product.Category Snippet of output Question #2: Within the ORDER schema, show all data from the CustomerOrder and ShipmentMethod tables SQL Query SELECT * FROM ORDERS.SHIPMENTMETHOD s,Orders.CustomerOrder c WHERE s.ShipmentMethodID = c.ShipmentMethodID Snippet of output Group-8 Group Assessment #1 PROG8650 – SECTION #2 Question #3: Within the ORDER schema, without using a WHERE statement, write a single SQL statement that shows the following data: - From the CustomerOrder table, show the OrderID and TotalPaid - From the ShipmentMethod table, show the shipment SQL Query SELECT c.OrderID,c.TotalPaid,s.ShipmentMode FROM ORDERS.SHIPMENTMETHOD s inner join Orders.CustomerOrder c on s.ShipmentMethodID = c.ShipmentMethodID Snippet of output Group-8 Group Assessment #1 PROG8650 – SECTION #2 Question #4: Within the ORDER schema, display all orders from the CustomerOrder table that have a total amount paid that is less than $1,000 Canadian dollars. - Display all the fields from the CustomerOrder table in your outpu [Show More]

Last updated: 2 years ago

Preview 1 out of 13 pages

Buy Now

Instant download

We Accept: