---

USE [database_kot]
GO

PRINT '--- 1. ПРОВЕРКА КОЛИЧЕСТВА ЗАПИСЕЙ В ТАБЛИЦАХ ---'
SELECT 'Address' AS [Таблица], COUNT(*) AS [Количество строк] FROM [dbo].[Address] UNION ALL
SELECT 'MaterialTypeImport', COUNT(*) FROM [dbo].[MaterialTypeImport] UNION ALL
SELECT 'NameArea', COUNT(*) FROM [dbo].[NameArea] UNION ALL
SELECT 'NameCity', COUNT(*) FROM [dbo].[NameCity] UNION ALL
SELECT 'NameDirector', COUNT(*) FROM [dbo].[NameDirector] UNION ALL
SELECT 'NameStreet', COUNT(*) FROM [dbo].[NameStreet] UNION ALL
SELECT 'NumberIndex', COUNT(*) FROM [dbo].[NumberIndex] UNION ALL
SELECT 'PartnerImport', COUNT(*) FROM [dbo].[PartnerImport] UNION ALL
SELECT 'PartnerProductImport', COUNT(*) FROM [dbo].[PartnerProductImport] UNION ALL
SELECT 'ProductImport', COUNT(*) FROM [dbo].[ProductImport] UNION ALL
SELECT 'ProductTypeImport', COUNT(*) FROM [dbo].[ProductTypeImport] UNION ALL
SELECT 'TypePartner', COUNT(*) FROM [dbo].[TypePartner] UNION ALL
SELECT 'UserRole', COUNT(*) FROM [dbo].[UserRole] UNION ALL
SELECT 'Users', COUNT(*) FROM [dbo].[Users];

PRINT '--- 2. ДЕМОНСТРАЦИЯ ДАННЫХ: ЖУРНАЛ ПРОДАЖ (СВЯЗАННЫЙ ЗАПРОС) ---'
SELECT 
    ppi.[Id] AS [ID Сделки],
    tp.[Type] + ' ' + p.[NamePartner] AS [Партнер],
    p.[NumberPhone] AS [Телефон],
    prod.[NameProduct] AS [Товар],
    ppi.[CountProduct] AS [Количество],
    prod.[MinPriceForPartner] AS [Цена за ед.],
    (ppi.[CountProduct] * prod.[MinPriceForPartner]) AS [Общая стоимость],
    FORMAT(ppi.[DataSales], 'dd.MM.yyyy') AS [Дата продажи]
FROM [dbo].[PartnerProductImport] ppi
JOIN [dbo].[PartnerImport] p ON ppi.[IdNamePartner] = p.[Id]
JOIN [dbo].[TypePartner] tp ON p.[IdTypePartner] = tp.[Id]
JOIN [dbo].[ProductImport] prod ON ppi.[IdProduct] = prod.[Id];