Исправил четвёртую лабу.

1 files changed, 9 insertions, 17 deletions

diff --git a/task4_requests.sql b/task4_requests.sql
index fc41e5d..a7eee14 100644
--- a/task4_requests.sql
+++ b/task4_requests.sql
@@ -16,10 +16,8 @@ GO
 
 -- составной
 
-SELECT Boxes.id, Orders.id, date
-FROM Boxes JOIN Orders
-ON Boxes.order_id = Orders.id
-WHERE Boxes.warehouse_id = 12465
+SELECT id, warehouse_id FROM Boxes
+WHERE warehouse_id = 12465
 GO
 
 CREATE INDEX Boxes_Composite ON Boxes (order_id, warehouse_id);
@@ -30,11 +28,8 @@ GO
 -- покрывающий
 
 SELECT * FROM Orders
-WHERE EXISTS(
-    SELECT * FROM Customers
-    WHERE customer_id = Customers.id
-        AND Customers.email LIKE N'%@mail.ru'
-);
+WHERE date > '2021-09-04'
+GO
 
 CREATE INDEX Orders_Index_Covering ON Orders (id)
     INCLUDE (customer_id, city_id, date);
@@ -53,15 +48,12 @@ GO
 
 -- индекс с включеными столбцами
 
-SELECT date FROM Orders
-WHERE EXISTS(
-    SELECT * FROM Customers
-    WHERE customer_id = Customers.id
-        AND Customers.email LIKE N'%@mail.ru'
-);
+SELECT id, customer_id, date FROM Orders
+WHERE customer_id = 12345
+GO
 
-CREATE INDEX Orders_Index_Columns ON Orders (id)
-    INCLUDE (customer_id, date);
+CREATE INDEX Orders_Index_Columns ON Orders (customer_id)
+    INCLUDE (id, date);
 GO
 DROP INDEX Orders_Index_Columns ON Orders;
 GO