MySQL

Do you realize how much time would be wasted for me to give all the information about the tables when you fail to mention the information you need from the tables, let's try to be specific here as opposed to a simple "question not proper" or "image not proper" how about you say why or define the parameters you need to answer the question

e /*1. Select the average mpg city and the average fuel cost annually, grouped by fuel type. Return the rows with the best mpg city first. Paste the sQL below. */ O /*2. Delete all of the records from the vehicle table that list a vehicle that has only 3 cylinders. Remember, to comply with your foreign key constraints, you must delete any related records in the uservehicle table first (leave no orphans). Paste the SQL statements below. */ /*3. Create a function that accepts an itemId as input and returns the number of items in stock. Paste the create function SQL below. */ or perform th task. O activitylog Pactivityl. ogld INT(11) activityoate DATETIME O activityText VARCHAR( 1000) Ouserld VAROHAR(50) O orderid INT(11) Indexes vehicle dvd Pvehideld INT (11) Omake VAROHAR (255) Omodel VARCHAR(255) users dvdid INT(11) ODVD Tite VAROHAR(255) Puserid VAROHAR (50) orders O frstname VARCHAR( 100) OStudo VAROHAR(255) Pordertd INT(11) O lastname VARCHAR(100) O year INT(11) Oeyinders INT (11) OReleased VARCHAR(255) Ousertd VARCHAR(S0) Omiddlelame VAROHAR(100) O Status VAROHAR(255) O orderDate DATETIME Ousername VAROHAR(20) Odsplacement VARCHAR(255) O Sound VAROHAR(255) O shippingDate DATETIME Opassword VARCHAR(20) Odrive VARCHAR(255) Indexes Oversions VARCHAR(255) O dob DATE O gender CHAR(1) O occupationld INT (11) Oengld INT(11) OPrice VAROHAR(255) Oeng dscr VARCHAR(255) O trany VARCHAR(255) Ompghighway VARCHAR(255) OmpgCity VARCHAR(255) ORatng VARCHAR(255) OYear VAROHAR(255) OuserStatustd INT(11) O Genre VARCHAR(255) O Aspect VAROHAR(255) item OuserTypeld INT(11) O created DATETIME Pitemid INT (11) iemName VAROHAR(100) OitemPrice DECIMAL (10,2) orderitem O fudCostAnnual INT(11) OUPC VARCHAR(255) Indexes orderid INT(11) O fuelType VARCHAR(255) ODVD_ReleaseDate VARCHAR(255) O O fuel Type1 VARCHAR(255) Oemid INT (11) Oquantity INT (11) O createdDate VARCHAR(255) Oprimarytmage VARCHAR (S0) ovass VAROHAR(255) O publicRating DECIMAL (4,2) OitemCategory V AROHAR( S0) Indexes Indexes Indexes Indexes vehicle vehideld INT(11) uservehicde Omake VAROHAR(255) PuserVehideld INT(11) Omodel VARCHAR(255) Ouserid VARCHAR(50) Oyear INT(11) Ocyinders INT (1) Odsplacement VARCHAR(255) Odive VAROHAR (255) Oengid INT(11) O vehideld INT (11) Indexes users Puserid VAROHAR (S0) O occupation Poccupationid INT (11) O frstname VARCHAR( 100) Oeng dscr VARCHAR (255) Olastname VARCHAR(100) Otrany VARCHAR(255) OmiddeName VARCHAR (100) O occupation VARCHAR(250) OmpgHighway VAROHAR(255) Indexes Ousername VARCHAR(20) Ompgoity VARCHAR(255) Opassword VARCHAR(20) O fueCostAnnual INT(11) O dob DATE O fueType VAROHAR (255) item Ogender CHAR(1) O fueTypel VARCHAR(255) Pitemid INT (11) Ooccupationid INT(11) dvd ovaas VARCHAR(255) itemName VAROHAR(100) OuserStatustd INT (11) dvdld INT(11) Indexes OiemPrice DECMAL (10,2) OuserTypeld INT(11) ODVD Tde VAROHAR (255) Oprimarydmage VARCHAR (S0) OitemCategory VARCHAR( 50) Ogreated DATETIME OStudio VARCHAR(255) Indexes OReleased VARCHAR(255) Indexes OStatus VAROHAR(255) O Sound VAROHAR(255) Oversions VARCHAR (255) userdvd PuserDvdid INT(11) OPrice VAROHAR(255) Ousertd VAROHAR(S0) Odvdld INT(11) ORating VARCHAR(255) D orders OYear VARCHAR(255) orderitem Indexes Porderid INT(11) Ouserld VARCHAR (50) O Genre VARCHAR255) ordertd INT(11) Oentd INT(1) OAspect VAROHAR(255) %23 OorderDate DATETIME OUPC VARCHAR (255) quantity INT (11) O DVD_ReleaseDate VARCHAR( 255) O createdo ate VAROHAR (255) O publicRating DECIMAL (4,2) OshippingDate DATETIME Indexes Indexes Indexes Tables used in this exercise e /*1. Select the average mpg city and the average fuel cost annually, grouped by fuel type. Return the rows with the best mpg city first. Paste the sQL below. */ O /*2. Delete all of the records from the vehicle table that list a vehicle that has only 3 cylinders. Remember, to comply with your foreign key constraints, you must delete any related records in the uservehicle table first (leave no orphans). Paste the SQL statements below. */ /*3. Create a function that accepts an itemId as input and returns the number of items in stock. Paste the create function SQL below. */ or perform th task. O activitylog Pactivityl. ogld INT(11) activityoate DATETIME O activityText VARCHAR( 1000) Ouserld VAROHAR(50) O orderid INT(11) Indexes vehicle dvd Pvehideld INT (11) Omake VAROHAR (255) Omodel VARCHAR(255) users dvdid INT(11) ODVD Tite VAROHAR(255) Puserid VAROHAR (50) orders O frstname VARCHAR( 100) OStudo VAROHAR(255) Pordertd INT(11) O lastname VARCHAR(100) O year INT(11) Oeyinders INT (11) OReleased VARCHAR(255) Ousertd VARCHAR(S0) Omiddlelame VAROHAR(100) O Status VAROHAR(255) O orderDate DATETIME Ousername VAROHAR(20) Odsplacement VARCHAR(255) O Sound VAROHAR(255) O shippingDate DATETIME Opassword VARCHAR(20) Odrive VARCHAR(255) Indexes Oversions VARCHAR(255) O dob DATE O gender CHAR(1) O occupationld INT (11) Oengld INT(11) OPrice VAROHAR(255) Oeng dscr VARCHAR(255) O trany VARCHAR(255) Ompghighway VARCHAR(255) OmpgCity VARCHAR(255) ORatng VARCHAR(255) OYear VAROHAR(255) OuserStatustd INT(11) O Genre VARCHAR(255) O Aspect VAROHAR(255) item OuserTypeld INT(11) O created DATETIME Pitemid INT (11) iemName VAROHAR(100) OitemPrice DECIMAL (10,2) orderitem O fudCostAnnual INT(11) OUPC VARCHAR(255) Indexes orderid INT(11) O fuelType VARCHAR(255) ODVD_ReleaseDate VARCHAR(255) O O fuel Type1 VARCHAR(255) Oemid INT (11) Oquantity INT (11) O createdDate VARCHAR(255) Oprimarytmage VARCHAR (S0) ovass VAROHAR(255) O publicRating DECIMAL (4,2) OitemCategory V AROHAR( S0) Indexes Indexes Indexes Indexes vehicle vehideld INT(11) uservehicde Omake VAROHAR(255) PuserVehideld INT(11) Omodel VARCHAR(255) Ouserid VARCHAR(50) Oyear INT(11) Ocyinders INT (1) Odsplacement VARCHAR(255) Odive VAROHAR (255) Oengid INT(11) O vehideld INT (11) Indexes users Puserid VAROHAR (S0) O occupation Poccupationid INT (11) O frstname VARCHAR( 100) Oeng dscr VARCHAR (255) Olastname VARCHAR(100) Otrany VARCHAR(255) OmiddeName VARCHAR (100) O occupation VARCHAR(250) OmpgHighway VAROHAR(255) Indexes Ousername VARCHAR(20) Ompgoity VARCHAR(255) Opassword VARCHAR(20) O fueCostAnnual INT(11) O dob DATE O fueType VAROHAR (255) item Ogender CHAR(1) O fueTypel VARCHAR(255) Pitemid INT (11) Ooccupationid INT(11) dvd ovaas VARCHAR(255) itemName VAROHAR(100) OuserStatustd INT (11) dvdld INT(11) Indexes OiemPrice DECMAL (10,2) OuserTypeld INT(11) ODVD Tde VAROHAR (255) Oprimarydmage VARCHAR (S0) OitemCategory VARCHAR( 50) Ogreated DATETIME OStudio VARCHAR(255) Indexes OReleased VARCHAR(255) Indexes OStatus VAROHAR(255) O Sound VAROHAR(255) Oversions VARCHAR (255) userdvd PuserDvdid INT(11) OPrice VAROHAR(255) Ousertd VAROHAR(S0) Odvdld INT(11) ORating VARCHAR(255) D orders OYear VARCHAR(255) orderitem Indexes Porderid INT(11) Ouserld VARCHAR (50) O Genre VARCHAR255) ordertd INT(11) Oentd INT(1) OAspect VAROHAR(255) %23 OorderDate DATETIME OUPC VARCHAR (255) quantity INT (11) O DVD_ReleaseDate VARCHAR( 255) O createdo ate VAROHAR (255) O publicRating DECIMAL (4,2) OshippingDate DATETIME Indexes Indexes Indexes Tables used in this exercise