Cliv-create

import { useState } from 'react'
import reactLogo from './assets/react.svg'
import viteLogo from '/vite.svg'
import './App.css'

function WelcomeMessage() {
    return (
        <>
            <h3>Hello! It's a test project to see how React + Vite and Typescript works!</h3>
            <p>My name is <a href="https://github.com/Cliv-create">Cliv-create</a> and im a student learning to become a software engineer!</p>

Cliv-create

1. Показать среднее арифметическое трёх вещественных чисел, хранящихся в переменных

DECLARE @f1 float
DECLARE @f2 float
DECLARE @f3 float
SET @f1 = 100.50
SET @f2 = 50.50
SET @f3 = 15.50
PRINT (@f1 + @f2 + @f3) / 3

Cliv-create

-- INNER JOINS

1. Показать названия и категории товаров, поставщиками которых являются ООО "Паньки" или ООО «Какие люди»

SELECT p.name, p.id_category
FROM Product AS p
JOIN Supplier AS s ON p.id_producer = s.id
JOIN Category AS c ON p.id_category = c.id
WHERE s.name IN ('ООО "Паньки"', 'Хлебзавод')

Cliv-create

USE [master]
GO
/****** Object:  Database [Resort]    Script Date: 27.02.2025 19:32:46 ******/
CREATE DATABASE [Resort]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Resort', FILENAME = N'D:\SQLDatabases\Resort\Resort.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Resort_log', FILENAME = N'D:\SQLDatabases\Resort\Resort_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF

Cliv-create

1. Посчитать возможную выручку за хлеб и молоко (с учётом скидок на эти товары)

SELECT price * quantity - (price * quantity / 100 * discount)
FROM Product

2. Получить информацию о том, каких товаров вчера и сегодня доставили более 10 штук (getdate, dateadd)

SELECT  p.name AS 'Название товара', p.date_of_delivery AS 'Дата доставки'
FROM Product p
WHERE date_of_delivery = CAST(GETDATE() AS DATE)

Cliv-create

USE [master]
GO
/****** Object:  Database [Restaurant]    Script Date: 10.02.2025 16:37:50 ******/
CREATE DATABASE [Restaurant]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Restaurant', FILENAME = N'D:\SQLDatabases\Restaurant\restaurant.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Restaurant_log', FILENAME = N'D:\SQLDatabases\Restaurant\restaurant_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF