Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Process Driven Database Design With Oracle PL SQL

Authors: Rajeev Kaula

1st Edition

1795532386, 978-1795532389

More Books

Students also viewed these Databases questions