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: 3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total…

A: we will be using C++ and object oriented approach. Also there is no grading system mentioned so we…

Q: What are the types of SQL Queries?

A:

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

A:

Q: In sql get to know the HR database, its tables, and their contents. Show the SQL query and the…

A: SQL: SQL stands for a structured query language, it used to manage the data and organize the data in…

Q: Explain the benefits of using the identity column capability in SQL.

A: The identity column generates the key values. It makes the increment in the unique values.

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: 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: 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: Student(StudentID, age) School(SchoolID, city) Write an SQL statement for the following query: For…

A: The above question is solved in step 2:-

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

A: SQL

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: 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: 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: 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: 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 character-manipulation functions? Explains its different types in SQL.

A: A character manipulation function in SQL is a function that allows you to manipulate characters in a…

Q: write my sql , p/sql pr t-sql procedures to retrieve and output the item id, description, location,…

A: Your mysql query is given below.

Q: Write the required SQL statements to create the PET_2 table

A: Here we will create the PET_2 table

Q: PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please…

A: Query for passenger info between dates.

Q: Topic: Sql in Ms Access How to display lastname and firstname of all employees in alphabetical order…

A: The select query will be used to select first name nad last name . Order by clause will be use…

Q: What is true about table functions in standard SQL? (a) table functions can operate on only one…

A: The table-valued function is a function that is able to return tables. Hence, correct answer is…

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

A: An index contains keys built from one or more columns in the table or view. These keys are stored in…

Q: Execute a SQL statement to delete the column status from order_db.

A: The DELETE statement in SQL is a powerful tool for putting off data from a database desk. It allows…

Q: Using the Online SQL Editor, answer the following questions with screenshots. Link:…

A: Hello student Greetings   The above question requires the use of SQL joins to retrieve data from…

Q: 2. Which of the following SQL statements deletes all rows in table called Sales Data? a) DELETE ALL…

A: Database is basically a software that manages the collection of related data. The data can be…

Q: Describe the process of creating a table in SQL and the different data types you can use for fields.

A: Given: Describe how to create a table in SQL and the various data types that may be used for fields.

Q: using the link below, select which data type best fits the following needs:…

A: Let's understand the scenario for the question first .  We have the various types of datatypes…

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.