smart-onion

smart-onion / InventoryDB.sql

Created August 15, 2024 10:36

	USE [master]
	GO
	/**** Object: Database [Inventory] Script Date: 8/15/2024 1:33:37 PM ****/
	CREATE DATABASE [Inventory]
	CONTAINMENT = NONE
	ON PRIMARY
	( NAME = N'Inventory', FILENAME = N'D:\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\Inventory.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
	LOG ON
	( NAME = N'Inventory_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\Inventory_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
	WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF

smart-onion / QueryHW

Created August 20, 2024 08:59


	-- Task 1
	SELECT name, price, discount, quantity , quantity * (price * (1- discount)) AS total
	FROM Product
	WHERE name LIKE '%bread%' OR name LIKE 'milk'

	-- Task 2
	SELECT name, quantity
	FROM Product
	WHERE date_of_delivery BETWEEN DATEADD(day, -2, GETDATE()) AND GETDATE() AND quantity > 100

smart-onion / html

Created May 7, 2025 13:35

JS1

	<!doctype html>
	<html class="no-js" lang="">

	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title></title>
	<link rel="stylesheet" href="css/style.css">
	<meta name="description" content="">

smart-onion / j.js

Last active May 12, 2025 10:47

JS2

smart-onion / hw.js

Created May 12, 2025 11:38

JS3

	let rectangle = {
	topLeft: {x:0, y:0},
	bottomRight: {x:0, y:0}
	}

	function width(rect){
	return rect.bottomRight.x - rect.topLeft.x;
	}
	function height(rect){
	return rect.topLeft.y - rect.bottom.y;