2.75 cups of flour The recipe produces 48 cookies with this amount of the ingredients. Write a program that asks the user how many cookies he or she wants to make, then displays the number of cups of each ingredient needed for the specified number of cookies. 7. Box Office A movie theater only keeps a percentage of the revenue earned from ticket sales. The remainder goes to the movie distributor. Write a program that calculates a theater's gross and net box office profit for a night. The program should ask for the name of the movie, and how many adult and child tickets were sold. (The price of an adult ticket is $10.00 and a child's ticket is $6.00.) It should display a report similar to: Movie Name: "Wheels of Fury" Adult Tickets Sold: 382 Child Tickets Sold: 127 Gross Box Office Profit: $ 4,582.00 Net Box Office Profit: $ 916.40 Amount Paid to Distributor: $ 3,665.60 NOTE: Assume the theater keeps 20 percent of the gross box office profit. 8. How Many Widgets? The Yukon Widget Company manufactures widgets that weigh 12.5 pounds each. Write a program the total weight of the pallet. The program should ask the user how much the pallet weighs by itself and with the widgets stacked on it. It should then calculate and display that calculates how many widgets are stacked on a pallet, based on cked on the pallet.

Explain the concepts from the figure.

Below are some rows of the PROVIDERS table for a factory:   PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821   All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate?     a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’   b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’   c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’   d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’

SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60; Q2: By Parent HeightCreate a table by_parent_height that has a column of the names of all dogs that have a parent,ordered by the height…

5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID

Add the provided information to a new record in the REP table. SELECT * FROM REP   Expected Results REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 35 Fred Kiser 427 Billings Dr. Cody WY 82414 307-555-6309 0.00 0.05

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.

Which clause of a SQL Select statement is required if we want to display aggregate data by category such as total population by state, department, etc.?   Question 40 options:   1)  GROUP BY   2)  ORDER BY   3)  WHERE   4)  FROM   5)  SELECT

Question 13: Evaluate ACE16 +102 10 and show the answer in octal form.

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'