Skip to content

Instantly share code, notes, and snippets.

#include <iostream>
using namespace std;
int main()
{
const float P = 3.1415;
int r;
cout << "vvedit radius: ";
cin >> r;
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
USE Store
SELECT Product.name AS Product_name, Producer.name AS Producer_name
FROM Producer
LEFT JOIN Product
ON Producer.id = Product.id_producer
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
prodevo / 1
Last active April 19, 2025 21:02
USE ATB
SELECT name,(price - (price * discount) / 100) * quantity AS [Можливий заробіток]
From Product
WHERE (name LIKE 'Хліб%' OR name = 'Молоко')
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
USE [master]
GO
/****** Object: Database [first] Script Date: 11.04.2025 19:19:01 ******/
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
#include <windows.h>
#include <iostream>
#include <ctime>
#include <conio.h>
#include "ConsoleApplication5.h"
using namespace std;
int main()
{
int window_settings();
@prodevo
prodevo / 1.cpp
Last active May 18, 2025 19:56
DZ_cpp_Umovy
#include <iostream>
using namespace std;
int main()
{
cout << "Vvedit pershe chyslo: ";
float a;
cin >> a;
cout << "Vvedit druge chyslo: ";
def draw_line(a, b, c):
if c == True:
print(b*a)
else:
for i in range(a):
print(b)
draw_line(20, '@', False)