Write insert statements to enter first two records into Table 1 as shown in above figure. b. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of author who has written Harry Potter book. How many books have been written by each author?

T-SQL procedure A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these valuse in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. B: obtain the order date, customer number and name for the order whose number currently is stored in I_ORDER_NUM. place these values in the variables I_ORDER_DATE, I_CUSTOMER_NUM and I_CUSTOMER_NAME , respectively. output the contents of I_ORDER_DATE, I_CUSTOMER_NUM , and I_CUSTOMER_NAME. C: add a row to the ORDERS table. D: change the date of the whole number is stored in I_ORDER_DATE to the date currently found in I_ORDER_DATE. E: delete the order whose number is stored in I_ORDER_NUM.

Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.

ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%

Write SQL code for the following: Create a stored procedure "setRelocationFee" to set the relocation fee for a givenemployee. If the employee’s office is in San Francisco, the relocation fee is 10000ドル; ifthe employee’s office is in Boston, the relocation fee is 8000ドル; if the employee’s officeis in London, the relocation fee is 20000ドル; if the employee works in other offices, therelocation fee is 15000ドル. (see image for table structure) I am stuck for the part that I have to select employeeNumber and officeCode and set the relocationFee to be able to obtain the result but I do not know how. Bellow is what I have gotten. Delimiter| CREATE PROCEDURE setRealocationFee(IN EmployeeID INT(11), OUT realocationFee INT(5))

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

You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.

in sql The ALTER SEQUENCE statement can be used to: Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d. Change the amount a sequence increments each time a number is generated

Database

In SQL, write the appropriate statements to insert default values ​​for these two tables, each table containing 5 inserts

Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.

SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings representing students names, and 2 integers representing the marks they received in DBS311. The function will determine which student had the higher mark and return the name of the student. If the marks were the same, then return the word "same" and return "error" if an error occurs or the calculation can not be determined.

Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than 300ドル. d. Display average of tax rates for all services.