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

Q: Discuss the SQL:1999 and SQL:2011 standards

A: SQL 1999 SQL:1999 (also known as SQL 3) was the fourth revision of the SQL standard. beginning with…

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: w do I view tables in SQL?

A: Microsoft SQL Server gives a data pattern view as one of a few strategies for getting this metadata.…

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

A: Update Command is used to update the value in a table. Alter command is used to change the value in…

Q: What is an alternative for the TOP clause in SQL?

A:

Q: Which statement should be used to stop a PL/SQL loop? EXIT WHEN GOTO…

A: The EXIT statement breaks out of a loop. The EXIT statement has two forms: the unconditional EXIT…

Q: Oracle SQL Packages Create a stored procedure to display top three of cheapest course in terms of…

A: To return the smallest value of the selected column we use the MIN( ) function. And to return the…

Q: DataBase Use EMP and DEPT tables, in the Live SQL, to perform the following operations. Upload your…

A: Hey there, I am writing the required solution(query) based on the above given question. Please do…

Q: Write a complete PL/SQL Cursor to retrieve the following information -Fetch row number, Employee id,…

A: Before executing the PLSQL statement first execute the command SET SERVEROUTPUT ON;. Otherwise the…

Q: How do I view tables in SQL?

A: In the given question  SQL stand for structured  query  language.

Q: Create the following tables in sql : Branch (branch-id, branch-name, branch-city) Customer…

A: According to the Question below the Solution below the Solution:

Q: A) Write PI/SQL code to print the odd numbers in the range from 5 to 25 Answer

A: Given:

Q: Please start from declare the variable  Using SQL*Plus and SQL Developer tool, complete the…

A: Structured query language is a querying database perform query against given data

Q: In SQL, what numeric data formats are available?

A: Tip Numeric data types are used to store numbers in database tables. Typically, these data formats…

Q: When creating a table in SQL, you must specify whether the column is NULL or NOT NULL.   a. True…

A: SQL

Q: In SQL Code: Write code snippet to show how value from Bind Variable can be passed to a PL/SQL…

A:

Q: How to add a new column in SQL?

A: A database management system (or DBMS). It is essentially just a computer-based data storage system.…

Q: The data set can contain many data tables Select one: True OFalse

A: A data set is an accumulation of linked, separate, tabularly presented related data items that can…

Q: Given two database table i_users(userid,username,email address,isActive,gender) stores the users…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: What are basic SQL commands?

A:

Q: Please use Pl/sql ro answer the following question, and red had been provide First create below…

A: The answer is...

Q: Write single-table queries using SQL commands.

A: Steps to write single query: SELECT col1, col2, ... FROM table_name; SELECT * FROM table_name;

Q: How do I view tables in SQL?

A: SQL stands for Structured Query Language and in this SQL, view is a virtual table which contains…

Q: Create a SQL statement to Display the CID, CName, Gender, and RType from bo

A: Answer: Always specify the tables to solve Sql i have solved it without table names if it does not…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

Q: Briefly describe how SQL:2011 differs from SQL:1999.

A: SQL-92 is the advanced version of Standard Query Language that is used to manage the data in the…

Q: Name the mandatory section of a PL/SQL block. Also briefly explain the three sections of a PL/SQL…

A: PL/SQL: It is an extended version of SQL. It is named so because it provides the data manipulation…

Q: Print out names, phone numbers, house ID, and status of people who live in the same house as anyone…

A: Database: A database acts as a storage of data. A large amount of data is being stored in the…

Q: List at least 3 differences between Oracle PL/SQL programming functions and procedures (Differences…

A: Differences between Oracle PL/SQL programming functions and procedures   S.N.   function…

Q: Explain the purpose of the CHECK clause within a CREATE TABLE SQL command. Explain the purpose of…

A: Given: Explain the purpose of the CHECK clause within a CREATE TABLE SQL command. Explain the…

Q: D d. COMMIT nis clause in SQL join is based on all bles that have the same name.

A: ANSWER IS D   NATURAL JOIN

Q: How to delete a table in SQL?

A: Introduction You can delete information from a table by deleting one or additional rows from the…

Q: e the different types of SQL functions.

A: function A function is a predefined expression that takes one or more arguments as input, processes…

Q: Explain extensIons to sQl?

A: A SQL file contains Structured search language (SQL), that may be a language wont to access and…

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.