Skip to content

Instantly share code, notes, and snippets.

View HubertArciszewski95's full-sized avatar
🏠
Working from home

HubertArciszewski95

🏠
Working from home
View GitHub Profile
@HubertArciszewski95
HubertArciszewski95 / If statements.py
Last active June 29, 2018 15:12
Program do maszyny z napojami
import sys
#price
water = 1.00
cola = 1.50
Redbull = 2.00
#Printing what machine have in menu
print("1.Water = $%s" % water)
print("2.Cola = $%s" % cola)
--Instagram database clone--
--SCHEMA--
-- users--
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(255) UNIQUE NOT NULL,
created_at TIMESTAMP DEFAULT NOW()
);
@HubertArciszewski95
HubertArciszewski95 / MySQL syntax.sql
Last active January 30, 2018 12:01
Syntax form test in MySQL course
SELECT
first_name,
last_name,
COUNT(rating) AS count,
IFNULL(MIN(rating),0) AS min,
IFNULL(MAX(rating), 0) AS max,
ROUND(IFNULL(AVG(rating), 0), 2) AS avg,
CASE
WHEN COUNT(rating) > 0 THEN 'ACTIVE'
ELSE 'INACTIVE'