项目作者： AskarBisembaev

项目描述：
queries using the Select, Where, Inner Join operators

高级语言： TSQL

项目主页：

项目地址: git://github.com/AskarBisembaev/SQL.git

创建时间： 2021-08-27T14:05:51Z
项目社区：https://github.com/AskarBisembaev/SQL
开源协议：
下载

SQL

Here are examples of queries database.

I used:

SQL to create queries
the Тorthwind database from which I took the data

Here is an example of one of the requests:

USE Northwind
GO
SELECT dbo.Products.ProductName AS [Product name], 
CAST(COUNT(dbo.[Order Details].OrderID) AS nvarchar) AS [Quantity of orders]
FROM dbo.Products INNER JOIN dbo.[Order Details]
ON dbo.Products.ProductID = dbo.[Order Details].ProductID
WHERE dbo.[Order Details].OrderID BETWEEN 10258 AND 10585
GROUP BY dbo.Products.ProductName, dbo.Products.ProductID
ORDER BY dbo.Products.ProductID


