A cake shop named "Whisk" has an online presence. It has multiple flavors of cakes supplied by various vendors. The manager wants to know the cost of the available quantity. Write a sql query to get the total cost of the available cakes. Code should run on Mysql. Data type along with the sample input and output is mentioned below:-Cake:ColumnTypeCake_IdintFlavorvarchar(100)Cost intProducervarchar(20)StockintSample Input :-Cake:Cake_idFlavorCostProducerStock1001Vanilla450Just bake81003Chocolate500Flower Aura121004Red velvet600Bakingo11005Strawberry700Bigbasket21006Cinnamon900Creamy11007Vanilla 900Creamy21008Mango900Just bake21009Strawberry550Creamy2Sample output - 17200

The database management system is the collection of data and information related to an organization.…

Answered: A cake shop named "Whisk" has an online…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

A cake shop named "Whisk" has an online presence. It has multiple flavors of cakes supplied by various vendors. The manager wants to know the cost of the available quantity. Write a sql query to get the total cost of the available cakes. Code should run on Mysql. Data type along with the sample input and output is mentioned below:-

Cake:

Column	Type
Cake_Id	int
Flavor	varchar(100)
Cost	int
Producer	varchar(20)
Stock	int

Sample Input :-

Cake:

Cake_id	Flavor	Cost	Producer	Stock
1001	Vanilla	450	Just bake	8
1003	Chocolate	500	Flower Aura	12
1004	Red velvet	600	Bakingo	1
1005	Strawberry	700	Bigbasket	2
1006	Cinnamon	900	Creamy	1
1007	Vanilla	900	Creamy	2
1008	Mango	900	Just bake	2
1009	Strawberry	550	Creamy	2