SQL SELECT ANY INFORMATION 2 COMPLEX SELECT QUERY 1)JOIN 2)Subquery…

Question Answered step-by-step SQL SELECT ANY INFORMATION 2 COMPLEX SELECT QUERY 1)JOIN 2)Subquery… SQL SELECT ANY INFORMATION2 COMPLEX SELECT QUERY1)JOIN2)SubquerySQL SCRIPT BELOW– Manufacturer ————————-CREATE TABLE Manufacturer(ID int NOT NULL PRIMARY KEY,Company_name nvarchar(250) NOT NULL,Legal_address nvarchar(250) NOT NULL,Country_of_origin nvarchar(50) NOT NULL,Phone_number int NOT NULL,Registration_number nvarchar(50) NOT NULL);– Vaccien ————————-CREATE TABLE Vaccine(ID int NOT NULL PRIMARY KEY,Name nvarchar(50) NOT NULL,Sertification nvarchar(50) NOT NULL,Manufacturer_ID int NOT NULL foreign key references Manufacturer(ID)); — User ————————-CREATE TABLE SiteUser(ID int NOT NULL PRIMARY KEY,Name nvarchar(50) NOT NULL,Surname nvarchar(50) NOT NULL,Personal_code nvarchar(50) NOT NULL,Email nvarchar(50) NOT NULL,Phone_number int NULL,Date_birth date NOT NULL,Parent_ID int foreign key references SiteUser(ID));– covid sick ————————-CREATE TABLE Covid_sick(ID int NOT NULL PRIMARY KEY,User_ID int NOT NULL foreign key references SiteUser(ID),Sick_leave_from date NOT NULL,Sick_leave_due date NULL,Covid_type nvarchar(50) NOT NULL);CREATE TABLE User_vaccination(ID int NOT NULL PRIMARY KEY,User_ID int NOT NULL,Vaccination_date date NOT NULL,Vaccine_ID int NOT NULL,Shot_number int NOT NULL,FOREIGN KEY (User_ID) REFERENCES SiteUser(ID),FOREIGN KEY (Vaccine_ID) REFERENCES Vaccine (ID));– Medical_center————————CREATE TABLE Medical_center(ID int NOT NULL PRIMARY KEY,Name nvarchar(50) NOT NULL,Legal_address nvarchar(250) NOT NULL,Phone_number int NOT NULL,Registration_number nvarchar (50) NOT NULL);CREATE TABLE Medical_center_vaccine(Medical_center_ID int NOT NULL foreign key references Medical_center(ID),Vaccine_ID int NOT NULL foreign key references Vaccine(ID),Amount int NOT NULL,Primary key(Medical_center_ID,Vaccine_ID));– Vaccination_point_address————————-CREATE TABLE Vaccination_point_address(ID int NOT NULL PRIMARY KEY,Address nvarchar(50) NOT NULL,Phone_number int NOT NULL,Medical_center_ID int NOT NULL foreign key references Medical_center(ID));– Time_slots————————-CREATE TABLE Time_slots(ID int NOT NULL PRIMARY KEY,Date date NOT NULL,Start_time time(7) NOT NULL,End_time time(7) NOT NULL,Vaccination_point_address_ID int NOT NULL foreign key references Vaccination_point_address(ID));– booking————————CREATE TABLE Booking(ID int NOT NULL PRIMARY KEY,User_ID int NOT NULL,Vaccine_ID int NOT NULL,Time_slot_ID int references Time_slots(ID),FOREIGN KEY (User_ID) REFERENCES SiteUser(ID),FOREIGN KEY (Vaccine_ID) REFERENCES Vaccine(ID));_________________– insert into SiteUser ————————————INSERT INTO SiteUser VALUES(‘1’, ‘John’, ‘Doe’, ‘123’, ‘..e@g, ‘12345678’, ‘1980-12-01’, NULL),(‘2’, ‘Jane’, ‘Doe’, ‘123’, ‘..e@’, ‘12345678’, ‘1983-04-01’, NULL),(‘3’, ‘Mill’, ‘Terrane’, ‘192928’, ‘..a@g.’, ‘12345678’, ‘1999-01-01’, 1),(‘4’, ‘Robert’, ‘Mike’, ‘1297979’, ‘..a@g.’, ‘298878’, ‘2000-06-01’, 2),(‘5’, ‘Grace’, ‘Hull’, ‘1289697’, ‘..a@g.c, ‘1278726’, ‘2010-10-01’, 2),(‘6’, ‘Lana’, ‘Sia’, ‘1261870’, ‘..n@g, ‘099828678’, ‘2010-10-01’, 2),(‘7’, ‘Angela’, ‘Bella’, ‘040597’, ‘..angela@g’, ‘875467’, ‘1997-10-01’, NULL),(‘8’, ‘Svetlana’, ‘Ratkina’, ‘050487’, ‘..ratkina@g’, ‘129864’, ‘1998-11-01’, NULL);– insert into Manufacturer ————————————INSERT INTO Manufacturer VALUES(‘1’, ‘COVISHIELD’, ‘CS3435443’, ‘India’, ‘424234’, ‘34534’),(‘2’, ‘JOHNSON & JOHNSON’, ‘JJ123’, ‘US’, ‘33123’, ‘432342’),(‘3’, ‘MODERNA’, ‘M3424’, ‘Russia’, ‘2323’, ‘45352’),(‘4’, ‘SINOPHARM’, ‘SP34242’, ‘London’, ‘45433’, ‘32432’),(‘5’, ‘BioNTech’, ‘BNT32435’, ‘US’, ‘453543’, ‘23424’);– insert into Vaccine ————————————INSERT INTO Vaccine VALUES(‘1’, ‘ASTRAZENECA’, ‘COVISHIELD COVID-19’, 1),(‘2’, ‘JANSSEN/ JOHNSON & JOHNSON’, ‘Ad26.CoV2.S’, 2),(‘3’, ‘MODERNA’, ‘mRNA-1273’, 3),(‘4’, ‘SINOPHARM’, ‘BBIBP-CorV’, 4),(‘5’, ‘Pfizer’, ‘BioNTech’, 5);– insert into User_vaccination ————————————INSERT INTO User_vaccination VALUES(‘1’, ‘1’, ‘2022-01-01’, ‘1’, ‘2’),(‘2’, ‘2’, ‘2022-01-12’, ‘2’, ‘1’),(‘3’, ‘3’, ‘2022-02-09’, ‘3’, ‘1’),(‘4’, ‘4’, ‘2022-04-01’, ‘4’, ‘1’),(‘5’, ‘5’, ‘2022-04-15’, ‘2’, ‘1’),(‘6’, ‘6’, ‘2022-04-15’, ‘5’, ‘1’);– insert into Covid_sick ————————————INSERT INTO Covid_sick VALUES(‘1’, ‘1’, ‘2022-01-03’, ‘2022-01-17’, ‘SARS-CoV-2’),(‘2’, ‘2’, ‘2022-01-03’, ‘2022-01-17’, ‘SARS-CoV’),(‘3’, ‘3’, ‘2022-01-13’, ‘2022-01-27’, ‘MERS-CoV’),(‘4’, ‘4’, ‘2022-02-10’, ‘2022-02-24’, ‘HCoV-NL63’),(‘5’, ‘5’, ‘2022-04-02’, ‘2022-04-16’, ‘SARS-CoV’),(‘6′, ’40’, ‘2022-01-02’, ‘2022-01-16’, ‘SARS-CoV’),(‘7′, ’41’, ‘2021-04-02’, ‘2021-04-16’, ‘SARS-CoV’),(‘8′, ’42’, ‘2021-11-02’, ‘2021-11-21’, ‘SARS-CoV’),(‘9′, ’12’, ‘2021-02-02’, ‘2021-02-28’, ‘MERS-CoV’),(’10’, ’48’, ‘2021-06-06’, ‘2021-06-21’, ‘MERS-CoV’),(’11’, ’19’, ‘2021-03-21’, ‘2021-04-06’, ‘MERS-CoV’),(’12’, ’22’, ‘2021-08-15’, ‘2021-08-30’, ‘ARS-CoV-2′),(’13’, ’30’, ‘2021-08-15’, ‘2021-08-30’, ‘ARS-CoV-2′),(’14’, ’22’, ‘2021-09-01’, ‘2021-09-21’, ‘ARS-CoV-2’);– insert into Medical_center ————————————INSERT INTO Medical_center VALUES(‘1’, ‘MFD’, ‘Dzirnavu iela 70’, ‘66102000’, ‘213131’),(‘2’, ‘VCA’, ‘Gogoļa iela 3’, ‘67799977’, ‘234242’),(‘3’, ‘Veselības Centrs 4’, ‘Krišjāņa Barona iela 117’, ‘67847100’, ‘242424’),(‘4’, ‘AS’, ‘Andreja Saharova iela 1’, ‘67136979’, ‘324234’),(‘5’, ‘Možums’, ‘Bruņinieku iela 8’, ‘67273435’, ‘23243’);– insert into Vaccination_point_address ————————————INSERT INTO Vaccination_point_address VALUES(‘1’, ‘Dzirnavu iela 70’, ‘66102000’, ‘1’),(‘2’, ‘Gogoļa iela 3’, ‘67799977’, ‘2’),(‘3’, ‘Krišjāņa Barona iela 117’, ‘67847100’, ‘3’),(‘4’, ‘Andreja Saharova iela 1’, ‘67136979’, ‘4’),(‘5’, ‘Bruņinieku iela 87’, ‘67273435’, ‘5’),(‘6’, ‘Vienības gat. 109’, ‘767868’, ‘1’),(‘7’, ‘Mūkusalas iela 71’, ‘767868’, ‘1’),(‘8’, ‘Rušonu iela 15’, ‘767868’, ‘1’),(‘9’, ‘Nīcgales iela 5’, ‘67799977’, ‘2’),(’10’, ‘Lāčplēša iela 38,’, ‘67799977’, ‘2’);– insert into Medical_center_vaccine————————————INSERT INTO Medical_center_vaccine VALUES(‘1’, ‘1’, ’20’),(‘2’, ‘2’, ’50’),(‘3’, ‘3’, ’30’),(‘4’, ‘4’, ’20’);INSERT INTO Time_slots VALUES(‘1’, ‘2022-01-03′, ’08:00:00.000000′, ’16:00:00.000000’, ‘1’),(‘2’, ‘2022-01-13′, ’08:00:00.000000′, ’14:00:00.000000’, ‘2’),(‘3’, ‘2022-02-08′, ’08:00:00.000000′, ’12:00:00.000000’, ‘3’),(‘4’, ‘2022-03-09′, ’08:00:00.000000′, ’11:00:00.000000’, ‘4’),(‘5’, ‘2022-04-04′, ’08:00:00.000000′, ’20:00:00.000000’, ‘5’),(‘6’, ‘2022-04-04′, ’08:00:00.000000′, ’21:00:00.000000’, ‘1’),(‘9’, ‘2022-04-06′, ’08:00:00.000000′, ’15:00:00.000000’, ‘1’); Computer Science Engineering & Technology MYSQL Share QuestionEmailCopy link Comments (0)