Skip to content

Instantly share code, notes, and snippets.

View sunmeat's full-sized avatar
🐈
MEOW

Oleksandr Zahoruiko sunmeat

🐈
MEOW
View GitHub Profile
@sunmeat
sunmeat / activity_main.xml
Created April 22, 2022 16:39 — forked from evik246/activity_main.xml
Кнопки на черном фоне с цветами радуги
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity"
android:background="@color/black">
<Button
@sunmeat
sunmeat / 24.11
Created December 22, 2023 11:07 — forked from FromMeloriWithLove/24.11
SELECT
DB_NAME(database_id) AS DatabaseName,
SUM(size) * 8 AS SizeInBytes
FROM
sys.master_files
WHERE
database_id > 4
GROUP BY
database_id
ORDER BY
@sunmeat
sunmeat / ProductQueries2.sql
Created January 15, 2024 14:23 — forked from SlavikArt/ProductQueries2.sql
Product SQL Queries 2
-- 3. Показать названия и цены товаров,
-- доставленных на протяжении последнего месяца.
SELECT name, price
FROM Product
WHERE date_of_delivery >= DATEADD(MONTH, -1, GETDATE())
-- 4. Показать на экран названия и цены товаров
-- с категорией "Кондитерские изделия", но только не торговой марки "Roshen"
SELECT name, price
FROM Product