LE Autumn 2020_MIS442 Final Te X Inbox.animaistamb7@gma s.google.com/forms/d/e/1FAIpQLSfqdZS 8vxGBUZQKVOFXRaabth9zuc_Tjmn6J87hto-OH_GbA/ Question 2D: Identity the correct code to show Item_Name and 2 po Item Price which is Available, Hem Item ID Available Status Item Price Item Name 201 $3.00 Sandwich 202 $5.00 Burger 203 $6.00 Hotdog 204 $8.00 Shawrma 205 $10.00 Fried Rice 206 $12.00 Fried Chicken 207 $8.00 Mixed Vegetable 208 $10.00 Thal Soup 209 $15.00 Chicken Sizzling 210 $12.00 Chicken Curry 211 $15.00 Beef Curry 212 $8.00 Corn Soup 213 $3.00 Vegetable Roll 214 $5.00 Chicken Roll 215 $7.00 Club Sandwich 216 $3.00 Noodles 217 $5.00 Pasta 218 52.00 Soft Drinks 219 $1.00 Water Bottle 220 $3.00 icecream 221 $2.00 Fuchka 222 $2.00 Coffee 223 SL.00 Tea 224 $3.00 Lemonade go) 810) 101 ero) 101 (0) Gro) ero) 010) 810) BO) BO 010) Bo 810) exi co) Blog Bol Do SOODUDDDDDDDDDD GO select itemName, Item Price from item where item status Available Autumn 2020 MIS442 Final Ter X Inbox - animaislam07@gmai _google.com/forms/d/e/1FAIpQLSfqdZSr8vxGBUZQEVOFXRaabth9zuc_jmn6J87hto-OH_GbA/ 219 $1.00 Water Bottle eo) 220 $3.00 Icecream 3(0) 221 $2.00 Fuchka (0) 222 $2.00 Coffee (0) 223 $1.00 Tea (0) 224 $3.00 Lemonade (0) SI EI KOSKI O select Item Name, item Price from item where item status 'Available select Item_Name, Item_Price from item where item_status=Available select item_Name, Item_Price from item where item_status="Yes" select Item Name, Item Price from item where item status= Yes Question 3A: What is the output of SQL code: select brand name from brand where brand_origin = USA 1 bo It will show the brand name which is originated from USA O O It will show all brand quality which is originated from USA There will be an error O Only USA brand_type will be shown Question 3: What is the outout SQL codes selection Amount from I Autumn 2020 MIS142 Final Ter X M Inbox - animaislamu7@gma s.google.com/forms/d/e/1FAIpQLSfqdZS;8vxGBUZQEVOFXRaabth9rucTjmn6J87hto-OH_GbA/lo 7 po Question 3B: What is the output of SQL code: select loan amount from loan where loan amount >=100000 and interest = 10% It will show the all loan amount on the basis of loan amount 100000 and above as well as interest rate is 10% It will show the all loan amount on the basis of either loan amount 100000 and above of interest rate is 10% There is an error in code All loan amount will be shown Question 3C: Identify if code is correct: select product_id, product_name from Inventory where available = "No" 7 point Correct code incorrect code Question 3D: What is the output of SOL code: select total bill from ordering where total bli>200 Tpoint LE Autumn 2020_MIS442 Final Te X Inbox.animaistamb7@gma s.google.com/forms/d/e/1FAIpQLSfqdZS 8vxGBUZQKVOFXRaabth9zuc_Tjmn6J87hto-OH_GbA/ Question 2D: Identity the correct code to show Item_Name and 2 po Item Price which is Available, Hem Item ID Available Status Item Price Item Name 201 $3.00 Sandwich 202 $5.00 Burger 203 $6.00 Hotdog 204 $8.00 Shawrma 205 $10.00 Fried Rice 206 $12.00 Fried Chicken 207 $8.00 Mixed Vegetable 208 $10.00 Thal Soup 209 $15.00 Chicken Sizzling 210 $12.00 Chicken Curry 211 $15.00 Beef Curry 212 $8.00 Corn Soup 213 $3.00 Vegetable Roll 214 $5.00 Chicken Roll 215 $7.00 Club Sandwich 216 $3.00 Noodles 217 $5.00 Pasta 218 52.00 Soft Drinks 219 $1.00 Water Bottle 220 $3.00 icecream 221 $2.00 Fuchka 222 $2.00 Coffee 223 SL.00 Tea 224 $3.00 Lemonade go) 810) 101 ero) 101 (0) Gro) ero) 010) 810) BO) BO 010) Bo 810) exi co) Blog Bol Do SOODUDDDDDDDDDD GO select itemName, Item Price from item where item status Available Autumn 2020 MIS442 Final Ter X Inbox - animaislam07@gmai _google.com/forms/d/e/1FAIpQLSfqdZSr8vxGBUZQEVOFXRaabth9zuc_jmn6J87hto-OH_GbA/ 219 $1.00 Water Bottle eo) 220 $3.00 Icecream 3(0) 221 $2.00 Fuchka (0) 222 $2.00 Coffee (0) 223 $1.00 Tea (0) 224 $3.00 Lemonade (0) SI EI KOSKI O select Item Name, item Price from item where item status 'Available select Item_Name, Item_Price from item where item_status=Available select item_Name, Item_Price from item where item_status="Yes" select Item Name, Item Price from item where item status= Yes Question 3A: What is the output of SQL code: select brand name from brand where brand_origin = USA 1 bo It will show the brand name which is originated from USA O O It will show all brand quality which is originated from USA There will be an error O Only USA brand_type will be shown Question 3: What is the outout SQL codes selection Amount from I Autumn 2020 MIS142 Final Ter X M Inbox - animaislamu7@gma s.google.com/forms/d/e/1FAIpQLSfqdZS;8vxGBUZQEVOFXRaabth9rucTjmn6J87hto-OH_GbA/lo 7 po Question 3B: What is the output of SQL code: select loan amount from loan where loan amount >=100000 and interest = 10% It will show the all loan amount on the basis of loan amount 100000 and above as well as interest rate is 10% It will show the all loan amount on the basis of either loan amount 100000 and above of interest rate is 10% There is an error in code All loan amount will be shown Question 3C: Identify if code is correct: select product_id, product_name from Inventory where available = "No" 7 point Correct code incorrect code Question 3D: What is the output of SOL code: select total bill from ordering where total bli>200 Tpoint