in SQL Code: What are Host Variables? How can you use Host Variables? Provide a detailed example with a select statement using an Employee Table

How are clustered and non-clustered indexes different in SQL?

USE this part to write SQL statements at the bottom questions 1-11   Branch(branch_id:integer, branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2)       create table Branch             (branch_id                              integer,     branch_name                                 varchar(50),     branch_location                 varchar(40),     money_on_hand                 numeric(15,2),     primary key (branch_id));   Loan(loan_number:integer, branch_id:integer, amount:numeric(8,2))                   foreign key branch_id references Branch(branch_id)   create table Loan       (loan_number            integer,     branch_id                                  integer,     amount                                     numeric(8,2),     primary key (loan_number),     foreign key (branch_id) references Branch (branch_id));   Customer(customer_id:integer, customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30),…

I need help with this question for my Database Management class for SQL developer. Thank you   REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)   Question: List TOY category items and orders placed for them.  Report:  Item_Num, Description, Order_Num, and Order_Date