Question: Can you please provide code in SQL workbench. ZAGIMORE: 1) Display the RegionIDs of regions where we have stores (use only table STORE and do


Can you please provide code in SQL workbench.
ZAGIMORE: 1) Display the RegionIDs of regions where we have stores (use only table STORE and do not display the same information more than once). (0.25 point) 2) Display all the information for all stores whose RegionID value is C. ( 0.25 point) 3) Display CustomerID and CustomerName for all customers whose CustomerName begins with a letter T. (0.25 point) 4) Display the ProductID, ProductName, and ProductPrice for products with a Product Price of $100 or higher. (0.25 point) 5) Display the TID and the total number of items (of all products) sold within the transaction for all sales transactions whose total number of items (of all products) sold within the transaction is greater than five. (0.25 point) HAFHMORE: 6) Display the CCID, CCName, and CCIndustry for all corporate clients, sorted alphabetically by CCName. (0.5 point) 7) Display all the records in the table STAFF MEMBER for staff members whose SMemberName begins with a letter B. ( 0.5 point) 8) Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that have more than one bedroom. (0.5 point) 9) Display the answer to the following question: How many HAFH buildings have exactly 4 floors? (0.5 point) 10) Display the total amount HAFH spends on manager salaries (as TotalSalary) and the total amount HAFH spends on manager bonuses (as TotalBonus). (0.5 point) 11) Display the ManagerID, MFName, MLName, MSalary, and MBonus, for all managers with a salary greater than $50,000 and a bonus greater than $1,000. (0.75 point) 12) Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that are not leased. (0.5 point) Section 2- Assignment: NOTE1: You must Upload one (just one!) SQL file (any other file formats are not accepted), which contains all queries. Codes should work without any ERROR. NOTE2: Each question's answer should include just one query. Multiple queries are not accepted. Example of one and two queries: One query: SELECT * FROM employees; Two queries: SELECT * FROM employees; SELECT * FROM employees where emp_no > 1000; NOTE3: In your sql file, separate questions' answers by using \# and typing the question number in front of it. Example: \#Question1 Answer: SELECT FROM employees where emp_no > 1000; \#Question2 Answer: SELECT * FROM titles where emp_no > 2000; NOTE4: Please submit only queries related to answers of the following questions, not tutorial exercises' solutions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
