This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 3. Показать названия и цены товаров, | |
-- доставленных на протяжении последнего месяца. | |
SELECT name, price | |
FROM Product | |
WHERE date_of_delivery >= DATEADD(MONTH, -1, GETDATE()) | |
-- 4. Показать на экран названия и цены товаров | |
-- с категорией "Кондитерские изделия", но только не торговой марки "Roshen" | |
SELECT name, price | |
FROM Product |