Skip to content

Instantly share code, notes, and snippets.

View amystas's full-sized avatar
🧠
pretending to be an intellectual

AmyStas amystas

🧠
pretending to be an intellectual
6 followers · 8 following
View GitHub Profile
@amystas
amystas / query.jsx
Created May 29, 2025 07:50
import React, { useEffect, useState } from "react";
import {
QueryClient,
QueryClientProvider,
useQuery,
} from "@tanstack/react-query";
const queryClient = new QueryClient();
export default function Pictures() {
const [pictures, setPictures] = useState(['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10']);
@amystas
amystas / index.php
Created April 23, 2024 10:34
<html>
<head>
<style>
table {
border-collapse: collapse;
}
td, th {
border: black solid 2px;
padding: 5px;
@amystas
amystas / bd19_kwerendy.sql
Created March 26, 2024 10:48
-- 1
SELECT CASE WHEN EXISTS ( SELECT * FROM user_details GROUP BY username HAVING COUNT(*) > 1 ) THEN 'tak' ELSE 'nie' END AS czy_istnieja_duplikaty;
-- 2
SELECT COUNT(user_id) AS liczba, first_name FROM `user_details` GROUP BY first_name ORDER BY `liczba` DESC;
-- 3
SELECT COUNT(user_id) AS liczba, last_name FROM `user_details` GROUP BY last_name ORDER BY liczba DESC;
-- 4
@amystas
amystas / roles.sql
Created February 7, 2024 20:38
INSERT INTO role (id, app_name, name) VALUES (1, 0, "Driver");
INSERT INTO role (id, app_name, name) VALUES (2, 3, "Driver");
INSERT INTO role (id, app_name, name) VALUES (3, 0, "Delivery man");
INSERT INTO role (id, app_name, name) VALUES (4, 3, "Delivery man");
INSERT INTO role (id, app_name, name) VALUES (5, 0, "Forwarding agent");
INSERT INTO role (id, app_name, name) VALUES (6, 3, "Forwarding agent");
INSERT INTO role (id, app_name, name) VALUES (7, 4, "Warehouse worker");
INSERT INTO role (id, app_name, name) VALUES (8, 3, "Warehouse worker");
INSERT INTO role (id, app_name, name) VALUES (9, 4, "Warehouse manager");
INSERT INTO role (id, app_name, name) VALUES (10, 3, "Warehouse manager");
@amystas
amystas / bazy_danych_15.sql
Last active January 30, 2024 12:00
-- Zadanie 3
ALTER TABLE `BD15`.`panstwa` ADD PRIMARY KEY (`id`);
ALTER TABLE `stolice` ADD PRIMARY KEY(`id`);
ALTER TABLE `stolice` ADD FOREIGN KEY (`id_panstwa`) REFERENCES `panstwa`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
-- Zadanie 4
-- a
SELECT `powierzchnia`, `ludnosc`, stolice.stolica FROM `panstwa` JOIN stolice ON stolice.id_panstwa = panstwa.id WHERE panstwa.panstwo = "polska";
-- b
SELECT COUNT(0) FROM `bd15`.`panstwa` WHERE `bd15`.`panstwa`.`panstwo` LIKE 'p%';
--c
@amystas
amystas / classes.ts
Created January 30, 2024 09:51
30-01-24 typescript class, basics of objects
class Student
{
public Age :number
public Name :string
constructor(age :number, name :string) {
this.Age = age
this.Name = name
}
@amystas
amystas / bazy_danych_11.sql
Last active December 5, 2023 09:54
-- zadanie 1
CREATE TABLE `zatrudnienie`.`stanowiska`
(`id_pracownika` INT NOT NULL AUTO_INCREMENT ,
`stanowisko` VARCHAR(40) NOT NULL ,
`numer_pokoju` INT NOT NULL ,
`data_stanowisko` DATETIME NULL ,
`data_mod_stanowisko` DATETIME NULL ,
PRIMARY KEY (`id_pracownika`));
-- zadanie 2
INSERT INTO `stanowiska` (`id_pracownika`, `stanowisko`, `numer_pokoju`, `data_stanowisko`, `data_mod_stanowisko`)
@amystas
amystas / bazy_danych_10.sql
Last active November 21, 2023 11:58
--1
SELECT COUNT(*) FROM imiona;
--2
SELECT COUNT(DISTINCT imie) FROM imiona;
--3
SELECT imie, COUNT(imie) FROM imiona GROUP BY imie;
--4
SELECT COUNT(imie) FROM imiona WHERE LENGTH(imie) = 5;
--5
SELECT COUNT(imie) AS "Liczba imion", LENGTH(imie) AS "Liczba liter" FROM imiona GROUP BY LENGTH(imie);
@amystas
amystas / bazy_danych_9.sql
Last active November 14, 2023 12:00
--3a
SELECT `rocznik`, COUNT(*) AS LiczbaSamochodow
FROM dane
GROUP BY `rocznik`
HAVING LiczbaSamochodow = (SELECT MAX(cnt) FROM
(SELECT `rocznik`, COUNT(*) AS cnt FROM dane GROUP BY `rocznik`) AS subquery);
--3b
SELECT dane.`nr_rej`, dane.marka, dane.model , `wartoscpocz` - `cenat` AS "in PLN" ,
CONCAT(MAX(ROUND(((`wartoscpocz`-`cenat`)/`wartoscpocz`)*100, 2)), '%') AS "Percent"
@amystas
amystas / olimpiada.py
Last active November 20, 2023 22:33
Zadanie 7 II serii OA 2023/24
import pandas
import re
import unicodedata
from math import sin, cos, pi
import matplotlib.pyplot as plt
import numpy as np
PATH = "gromady.xlsx"
data = pandas.read_excel(PATH)