Marie-zaj

IF DB_ID('BarberShopDB1') IS NULL
    CREATE DATABASE BarberShopDB1;
GO

USE BarberShopDB1;
GO


DROP PROCEDURE IF EXISTS GetTopBarberByDateRange;
DROP PROCEDURE IF EXISTS GetBarberSchedule;

Marie-zaj

USE Academy5;
GO


CREATE OR ALTER PROCEDURE Task1
AS
SELECT DISTINCT LR.Name
FROM LectureRooms LR
JOIN Schedules S ON S.LectureRoomId = LR.Id
JOIN Lectures L ON L.Id = S.LectureId

Marie-zaj

USE Academy4;
GO


SELECT DISTINCT LR.Name
FROM LectureRooms LR
JOIN Schedules S ON LR.Id = S.LectureRoomId
JOIN Lectures L ON S.LectureId = L.Id
JOIN Teachers T ON L.TeacherId = T.Id
WHERE T.Name = 'Edward' AND T.Surname = 'Hopper';

Marie-zaj

USE Academy3;
GO

SELECT COUNT(*)
FROM Teachers
WHERE Id IN (
    SELECT TeacherId
    FROM Lectures
    WHERE SubjectId IN (
        SELECT Id

Marie-zaj

SELECT Building
FROM Department
GROUP BY Building
HAVING SUM(Financing) > 100000;

SELECT Name
FROM StudentGroup
WHERE Year = 5
AND DepartmentId =
(

Marie-zaj

--CREATE DATABASE SportShop;
--GO

USE SportShop;
GO


CREATE TABLE Employees
(
    EmployeeId INT IDENTITY(1,1) PRIMARY KEY,

Marie-zaj

#include <iostream>
#include <vector>
using namespace std;

class House;
class Bank;
class Factory;

class Visitor 
{

Marie-zaj

#include <iostream>
#include <string>
using namespace std;

class RouteStrategy 
{
public:
    virtual void buildRoute(const string& A, const string& B) =  0;
    virtual ~RouteStrategy() {}
};

Marie-zaj

#include <iostream>
#include <string>
using namespace std;

class Herbivore
{
public:
	int weight;
	bool life;

Marie-zaj

#include <iostream>
#include <string>
using namespace std;

class Transport
{
public:
    virtual void input() = 0;
    virtual void info() = 0;
};