Question: Third question: Grade Use the following database schema to answer the following using SQL statements: Country (Ctid, ctname, capital) PK: Ctid Items (Itemid Iname, expdate,

 Third question: Grade Use the following database schema to answer thefollowing using SQL statements: Country (Ctid, ctname, capital) PK: Ctid Items (Itemid

Third question: Grade Use the following database schema to answer the following using SQL statements: Country (Ctid, ctname, capital) PK: Ctid Items (Itemid Iname, expdate, price, qty, Ctid) PK :Itemid. FK Ctid references Country 1-Create Table country with PK and ctname should be required.) 2- Display all Itemid, item name and county name for all items made by Jordan 3- Find total number of Items and sum of prices for each country sorted by sum descending only for sum of prices less than 10 JD. 4- List all Item name price for all expire date in December 2016. Grade 5- Display all item name and country id county name for all items with price less than 5 6- Find total number of Items and average of prices for each country sorted by average ascending only for expire date in 2016 7- List all Item name, Item id , price for all items made by country 101, 102

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!