sunmeat

#include <iostream>
#include <curl/curl.h>
#include <string>
using namespace std;

/*
1) заходим на https://github.com/microsoft/vcpkg
2) качаем архив (code > download)
3) распаковываем архив, переносим файлы в C:\vcpkg
4) запускаем bootstrap-vcpkg.bat, в папке сформируется vcpkg.exe

sunmeat

AndroidManifest.xml:

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools">
...
    <uses-permission android:name="android.permission.INTERNET" />
    <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
    <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
...

sunmeat

AndroidManifest.xml:

...
<uses-permission android:name="com.android.alarm.permission.SET_ALARM" />
...

==============================================================================================

MainActivity.java:

sunmeat

MainActivity.java:

package com.sunmeat.calendar;

import android.Manifest;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.content.Context;
import android.content.pm.PackageManager;
import android.os.Build;

sunmeat

AndroidManifest.xml:

...
 <uses-feature
        android:name="android.hardware.telephony"
        android:required="false" />
<uses-permission android:name="android.permission.CALL_PHONE" />
<uses-permission android:name="android.permission.READ_PHONE_STATE" />
...

ImShizer

DECLARE @a float = 26.32
DECLARE @b float = 24.1
DECLARE @c float = 46.12

PRINT (@a + @b + @c) / 3

IF DATEPART(HOUR, GETDATE()) BETWEEN 4 AND 11
BEGIN 
	PRINT 'С добрым утром!'
END

ImShizer

ELECT p.name, pr.name
FROM Products p RIGHT OUTER JOIN Producer pr ON p.id_producer = pr.id

SELECT p.name, c.name
FROM Products p RIGHT OUTER JOIN Category c ON p.id_category = c.id
WHERE p.name IS NULL 

SELECT name
FROM Region
EXCEPT 

ImShizer

SELECT p.name
FROM Sale s JOIN Products p ON s.id_product = p.id
WHERE s.price > 50

SELECT c.name
FROM Delivery d JOIN Products p ON d.id_product = p.id
JOIN Category c ON p.id_category = c.id
WHERE d.price >= 50

ImShizer

USE Products

-- Task 1
SELECT p.name, c.name, pr.name
FROM Products p JOIN Category c
ON p.id_category = c.id
JOIN Producer pr
ON p.id_producer = pr.id
WHERE p.id_producer <> 1 AND p.id_producer <> 2
AND pr.name NOT LIKE '%[АКМ]%' AND p.id_category <> 3

ImShizer

USE Store

SELECT *
FROM Product
WHERE DATEDIFF(M, date_of_delivery, GETDATE()) <= 1

SELECT name, price
FROM Product
WHERE producer = 'Roshen' AND category = 'Кондитерские изделия'