prodevo

USE [master]
GO
/****** Object:  Database [first]    Script Date: 11.04.2025 19:54:23 ******/
CREATE DATABASE [first]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'first', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\first.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'first_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\first_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF

prodevo

USE ATB
SELECT name,(price - (price * discount) / 100) * quantity AS [Можливий заробіток]
From Product
WHERE (name LIKE 'Хліб%' OR name = 'Молоко')

prodevo

USE Store

SELECT Product.name, Category.name

FROM Product

INNER JOIN Category ON Product.id_category = Category.id
INNER JOIN Delivery ON Delivery.id_product = Product.id
INNER JOIN Supplier ON Delivery.id_supplier = Supplier.id
WHERE Supplier.name = 'Везе Тобі Все' OR Supplier.name = 'Бусік Пандори'

prodevo

USE Store
SELECT Product.name AS Product_name, Producer.name AS Producer_name
FROM Producer

LEFT JOIN Product
ON Producer.id = Product.id_producer

prodevo

USE Store
SELECT Category.name, COUNT(Product.id) AS product_count
FROM Product

INNER JOIN Category
ON Product.id_category = Category.id

INNER JOIN Delivery
ON Product.id = Delivery.id_product

prodevo

#include <iostream>
using namespace std;

int main()
{
	const float P = 3.1415;
	int r;

	cout << "vvedit radius: ";
	cin >> r;