Write an SQL statement that will: List the 2017 make and models of autos that have a rebate amount worth more than $1000, but only for those autos bought in August 2016. Use the following database schema to write your SQL statement. AUTOS (AutoID, Make, Model, Year, MSRP, RebateID) SALESMAN (SMID, SMFName, SMLName, MgrID) MANAGER (MgrID, MgrFName, MgrLName) REBATE (RebateID, Description, RebateAmount) AUTOSALES (AutoID, CustomerID, SalesDate) CUSTOMER (CustomerID, CustFName, CustLName, Email, SMID)

Write a program to compute the ideal weight for both males and females in java. according to one study, the ideal weight for a female is 100 pounds plus 5 pounds for each inch in height over 5 feet. for example, the ideal weight for a female who is 5'3" would be 100 + 3*5 = 115 pounds. for a male, the ideal weight is 106 pounds plus 6 pounds for each inch in height over 5 feet. for example, the ideal weight for a male who is 5'3" would be 106 + 3*6 = 124 pounds. your program should ask the user to enter his/her height in feet and inches (both as integers—so a person 5'3" would enter the 5 and the 3). it should then compute and print both the ideal weight for a female and the ideal weight for a male. the general outline of your main function would be as follows: (1) declare your variables (think about what variables you need—you need to input two pieces of information, then you need some variables for your calculations (see the following steps) (2) get the input (height in feet and inches) from the user (3) compute the total number of inches of height (convert feet and inches to total inches (note: 1 foot equal 12 inches and hence 5 feet equal 60 inches. (4) compute the ideal weight for a female and the ideal weight for a male (5) print the answers.