Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started