Using Northwind.sql database

plz upload a screen print of each report.

Perform the query exercises to said BD; creating those queries that are necessary in SQL Language, so that you obtain the information that is requested of you In the REPORT section.

REPORTS AND REPORTS

(Queries in SQL)

REPORT5 #01

Consult and report the name of the database that was created on your PC and that you will be

Used in this activity.

(To do this, you must investigate and execute the SQL command that gives you the name of the DB

"In use"; additionally add a "label" to the result obtained, using the "word

SQL" )

REPORT #02

Check the average unit price of all products.

(Add a "label" = (title to the result column))

REPORT #03

Check what are the different = (unrepeat)... paternal surnames that our employees have, but only in the range from the initials "A" to "F"

REPORT #04

Italy

Check the names of those customers, who are our contacts in the USA, Spain and

REPORT #05

Check the names of all those products and their unit price, which have been sold to our customers in the USA; without repeating products with the same name.

REPORT #06

Consult the name and surname of the contacts of all our customers, who have been served by our employees; but only of those customers, whose surname begins with a letter "A"

REPORT #07

Consult the name of the product and the units = (parts) that were sold, in the "largeest" sale that has been made (that is, in a single operation = in the same Order of

Purchase )

REPORT #08

Consult the name and surname, only of those employees who have processed

Purchase Orders; to each employee, include the total number of orders he has fulfilled = (dragged).

REPORT #09

Generate the following report = (run the following query), showing the result obtained and

Explain later:

What operation = (query) is being performed in the following script?

USE northwind

SELECT TOP 5 WITH TIES orderid, productid, quantity

FROM order_details

ORDER BY quantity DESC

REPORT #10

Generate the following report = (run the query), showing the result obtained and explaining:

What operation = (query) is being performed in the following script?

USE nortlhwind

SELECT productid, SUM(quantity) AS total_quantity

FROM order details

GROUP BY productid

HAVING SUM (quantity) > 1200

REPORT #11

Explain:

Generate the following report = (run the following query), showing the result obtained and

What operation = (query) is being performed in the following script?

USE nortlhwind

SELECT DISTINCT region

FROM customers

WHERE region IS NOT NULL

REPORT #12

He explains:

Generate the following report = (run the following query), showing the result obtained and

What operation = (query) is being performed in the following script?

USE nortlhwind

SELECT *

FROM products

WHERE unitprice > ANY

(SELECT unitprice

REPORTES (Queries on SOL) REPORTE A 01 Consultar y reportar el nombre de la BD que se ha creado en tu PC y misma que estaras utilizando en esta Actividad. P Pura ello, deberats investigar y ejecutar el comando 501 que te obtenga el nombre de la BD "en uso; adiclonalmente agregale una "etiquete" al resultado obtenldo, usando ta "patabra SOL. cas=1 REPORTE \#02 Consultar el precio unitario promedio de lodos los productos. (Agregario una "efiquete" * [tifulo a ta columno del resultadol) REPORTE AO3 Consultar cuales son los distintos = isin Jepetif.. apellidos paternos que tienen nuestros REPORTE \#04 Consultar los nombres de aquellos clientes, que ton nuestros contactos en USA, Spain e ttaly REPORTE \#05 Consultar cuales-son los nombres de todos aquellos productos y su preclo unitario, que se hayan vendido a nuestros clientes de USA; sin repetir productos con ef mismo nombre. REPORTE $06 Consultar el nombre y apellido de los contactos de todos nuestros clientes, que han sido atendidos por nuestros empleados: pero solo de aquellos clientes, cuyo apeltido inicie con una lotra " A " REPORTE 107 Consultar ol nombre del producto y las unidades = pieras/ que se vendieron, en la venta "mas grande* que se haya realizado les decic, en una sola operacion = en un mismil Orden de Compra cPedidonl REPORTE 08 Consultar el nombre y apellido, solo do aquellos empleados que han tramitado epedidos? Oidenes de Compra; a cada empleado, incluitle el total de pedidos que haya atendido = (tramitado). REPORTE 09 Generar el siguiente reporte = fejecutar el siguiente coery), mostrando el resultado obtenido y explicar postoriormente: Que operacion = (consulta) se esta reatizando en la siguiente secuencia de comandos? USE northwind SFI,EOT TOP.5 WITH.TLES onderid, prodoctid, quantiry FROM order_detalis ORDEA AY quantity DESC REPORTE =10 Generar el siguiente toporte = (ejecurar ol query, mostrando el fesultado obtenido y explicar: Que operacion * (consutral se esta realizando en ta siguiente secuencia de comandos? USE nortifwind SELECT productid, SUMiquantify) AS total_quantity FROM onder details GROUP a Y productid HAVING SUMA (quantity) - 1200 REPORTE 111 Generar el siguiente teporte = (ejecutar el sigoiente queryl, mostrando el resultado obtenido y explicar: Que operacion * fconsulta! se esta realizando en la siguiente secuencia de comundos? USE norkhwind SELECT DISTUNCT region FROM customers WHERE rogion is NOT NULL. REPORTE 12 Generar el siguiente reporte = (ejecutar el siguiente query), mostrando el resultado obtenido y explica: Qu operacin = (consulra) se esta realizando en ta siguiente socuencia de comandos? GSE northwind SELECI : FROM produCts WHERE undiprice > ANY ISELECT onipprice