Create the following table in your database with the following schema: Table: Orders | Column Name | Туре -+- | int I order number | customer number | int +---- --- order number is the primary key for this table. This table contains information about the order ID and the customer ID. Add the following data to your tables: Input: Orders table: +--- --- | order_number | customer_number | +-- | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 3 Write an SQL query to find the customer_number for the customer who has placed the largest number of orders. The results should be: Output: 十-- --+ | customer number | +-- | 3

Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows:   ) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_idas an input parameter to show its corresponding node id to the banker. Then execute this procedure withcust_id=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.

Trigger please

You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause).  (you MAY use 1 or 2 statements)  Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int , empInitial char(30) , years int );   Write the SQL syntax to create an insert statement for the employee table you created above.

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

In SQL code: Create a PL/SQL block to retrieve the name of each employee from the EMPLOYEE table and print the first initial of each name on the screen, incorporating an INDEX BY table.

Do fast please.

This question should be answered in PL/SQL only!   Create a procedure that takes instructor_ID as a parameter. Name it INSTR_SECTIONS. The procedure displays instructor first and last names, and also a list of sections that the instructor is scheduled to teach. Only one instructor per procedure call. You give/pass to a procedure instructor_ID as a parameter, the procedure prints INFO related only to that instructor.