Using DML SQL, write the appropriate SQL query for each of the following: a) Insert A new customer with the following information: (Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555) b) Delete all the loans for customer with SSN: 2222 c) Select all customer who got loans more than 250000 SAR, print the customers SSN, name d) Print all the Accounts in Bank: ALBILAD and in branch no: 5

MICROSOFT SQL SERVER ONLY CURSOR T-SQL Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT.

Solmaris is offering a monthly discount for owners who pay their condo fees on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each condo, list the location number, unit number, owner number, owner’s last name, condo fee, and discount. The discount should be rounded to the nearest dollar. Snip and paste the SQL command(s) and results below. SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet to research these functions. Are the functions available in Oracle, SQL Server, and Access? Write a paragraph that discusses what the functions do and any differences and/or similarities between the functions in Oracle, SQL Server, and Access. Then perform the following tasks: Solmaris Condominium Group would like to know the impact of discounting its condo fees by 3 percent. Write an SQL statement in MySQL that displays the condo ID, unit number, discounted condo fee, discounted condo fee with the CEIL function, and...

What use cases are best suited for the CROSS APPLY function in SQL?

Write an SQL query using the IN operator to show all customers residingin the following zip codes: 91508, 91510, 33111

Write all the sql code (including create, insert and select)

Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to the state of Florida

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

Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerLastName,CustomerFirstName, Phone, CourseNumber, and AmountPaid

Write a query in SQL to display all the data of customers, in Table customers, that live in New York or California SELECT city FROM customers WHERE city = 'New York' OR city = 'California' SELECT * FROM customers WHERE city = 'New York' AND city = 'California' SELECT * FROM customers WHERE city = 'New York' OR city = 'California' SELECT ALL FROM customers WHERE city = 'New York' OR city = 'California' %3D

using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount

Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order. Find all patients rows whose first names include ‘George’ (Assume case sensitivity). sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR...

Do fast please.