Create the following table in your database with the following schema: Table: Sales | Column Name | Type | sale id I product name | varchar | | sale_date int I date +--- sale id is the primary key for this table. Each row of this table contains the product name and the date it was sold. Add the following data to your tables: Input: Sales table: +---------+- | sale id| product name | sale date +- | 2000-01-16 | | 2000-01-17 | | 2000-02-18 | 2000-02-19 | | 2000-02-28 | | 2000-03-31 | | 1 | 2 | 3 | LCPHONE | LCPhone | LcPhOnE | LCKeyCHAiN | LCKeyChain | Matryoshka | 5 Since table Sales was filled manually in the year 2000, product_name may contain leading and/or trailing white spaces, also they are case-insensitive. Write an SQL query to report • product_name in lowercase without leading or trailing white spaces. • sale_date in the format ("YYYY-MM'). • total the number of times the product was sold in this month. Return the result table ordered by product_name in ascending order. In case of a tie, order it by sale_date in ascending order. Hint: you may need to use the following functions: • LOWER() • TRIM() • DATE_FORMAT() The results should be: Output: +- I product name | sale date total +- | lckeychain | lcphone | lcphone | matryoshka | 2000-02 | 2000-01 | 2000-02 | 2000-03 | 2 | 2 | 1 | 1 +----- ------+

What is true about table functions in standard SQL?(a) table functions can operate on only one table(b) table functions can accept entire tables as input arguments(c) table functions can return tables(d) All of the above

What is an index in SQL? Also write it's syntax.

order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date

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

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

Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Select

Using php and sql:  create a query that will output only the user_id and message for user_id 8

in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example