Changes between Version 5 and Version 6 of Напредни извештаи од базата (SQL и складирани процедури)

Timestamp:

02/13/25 02:37:50 (10 days ago)

Author:

173067

Comment:

--

Напредни извештаи од базата (SQL и складирани процедури)

@@ -27 +27 @@
 {{{
 
+
 CREATE VIEW AverageDestinationRatingReport AS
 SELECT
@@ -35 +36 @@
     Review r
 JOIN
-    Destination d ON r.target_id = d.DestinationID
+    Destination d ON r.targetid = d.DestinationID
 GROUP BY
     d.destinationid, d.name
@@ -138 +139 @@
 
 CREATE VIEW FrequentFlightReviewers AS
-SELECT 
-    u.userid, 
-    u.name, 
-    u.surname, 
-    COUNT(r.review_id) AS NumberOfReviews
-FROM 
+SELECT
+    u.userid,
+    u.name,
+    u.surname,
+    COUNT(r.reviewid) AS NumberOfReviews
+FROM
     Review r
-JOIN 
+JOIN
     application_user u ON r.userid = u.userid
-WHERE 
-    r.target_id IN (SELECT FlightID FROM Flight)
-GROUP BY 
+WHERE
+    r.targetid IN (SELECT FlightID FROM Flight)
+GROUP BY
     u.userid, u.name, u.surname
-ORDER BY 
+ORDER BY
     NumberOfReviews DESC;
 
@@ -162 +163 @@
 
 CREATE VIEW PaymentMethodSpendReport AS
-SELECT 
-    p.payment_method, 
+SELECT
+    p.payment_method,
     SUM(p.Amount) AS TotalAmountSpent
-FROM 
+FROM
     Payment p
-GROUP BY 
+GROUP BY
     p.payment_method
-ORDER BY 
+ORDER BY
     TotalAmountSpent DESC;