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

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)…

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

DO NOT COPY FROM OTHER WEBSITES Upvote guarenteed for a correct and detailed answer. Thank you!!!

3 List the name of project that has most of working hours. SQL programming Pls show SQL codes for this and result! Pls do not spam!

answer with proper explanation and step by step solution. Question write a PL/ SQL program to display the number of products whose price is 100 dh more or less than the price defined the for substitution variable use the define command to specify the price pass this value to the PL/SQL black using a substitution variable

Please solve question no. 10 including screenshots of SQL results.

Use PL/SQL in oracle sql developer  Feature :Given a start and end date, print out name, phone number, status and event ID of people who attended the same event with someone whose status is 1 (tested positive) and the event date is between the start and end date. Feature : print out names of people who have recovered. A person has recovered if the person tested positive before but the current status is 0 (not positive).