Q1. Create a stored procedure that will list all customers (name and number) represented by rep 15. (SQL)

Write a SQL command please   Display the last name, job, salary, and commission percent for all employees who earn a commission and have a salary of at least 2500 but not more than 7000. Use descriptive titles.

3. Determine which orders were shipped to the same state as order 1014. SQL commands

Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed. Assume that the table name is 'student' Use the editor to format your answer

Create a SQL statement to Display the RID, RType, Rate, and Room_Status of all ROOMS whose rate is from 20 to 30 or room_status is Available.

Database  Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…

I use Microsoft SQL please I really need help

Subqueries--Create an sql script to answer the following questions.--List all products whose unit price is less than the average price.--List the shipper id, shipping company and freight cost for the order with the lowest freight charge.--List all products with their highest unit price, i.e. not discounted. --List the average unit price for each product category and--the average unit price without discounts

A SQL Data Manipulation command like UPDATE or INSERT immediately saves the result to disk without further intervention from the user.   Question 31 options:   1) True   2) False

please use sql to answer the following question