Question: please do it as soon as possible thankyou Consider the following tables: STORE with primary key Storeld, PRODUCT with primary key ProductId, and SALES_FACT with

please do it as soon as possible
thankyou  please do it as soon as possible thankyou Consider the following
tables: STORE with primary key Storeld, PRODUCT with primary key ProductId, and

Consider the following tables: STORE with primary key Storeld, PRODUCT with primary key ProductId, and SALES_FACT with composite primary key (Storeld, Productld), foreign key Storeld (referencing Storeld in STORE table) and foreign key Productid (referencing ProductId in PRODUCT table). PRODUCT STORE Producted Description Brand Storeld City Region Toy Story Wolf 1 New York East Parabuster Sense and Sensibility 2 Chicago Central Holiday of the Year Wolf Atlanta 4 Pulp Fiction MKF Studios Los Angeles West The Juror MKF Studios 5 San Francisco West Parabuster From Dusk till Dawn Philadelphia 7 Hellraiser: Bloodline Big Studios 1 2 Inc. 3 3 East 4 5 6 6 Inc. East SALES_FACT Storeld Productid Price Cost Profit 1 6 3.5 2.2 1.3 1 2 4.2 3.5 0.7 2 7 7.6 6.8 0.8 3 2 1.8 1.2 0.6 5 3 5.6 4.5 1.1 5 1 7.8 6.5 1.3 1 2 3 Write SQL statement to display all data of all products which have brand Wolf and have their description start with the letter Write SQL statement to display the stores Ids who have price for any product to be greater than 3. The stores ids should not repeat in the result of the SQL statement. Also, display the stores ids in descending order. Write SQL statement to display Productld of those products who have their brands to be one of the following: Wolf, MKF Studios, or Big Studios. Write SQL statement to find how many products that store with Storeld 7 have sold. Write SQL statement to find how many products that each store have sold displaying the storeld and how many products sold per store. Write SQL statement to find the stores Ids, the products Ids and products descriptions, and the profit of sales done, 45 6

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!