Changes between Version 4 and Version 5 of UseCase07

Timestamp:

12/14/22 14:51:47 (2 years ago)

Author:

181085

Comment:

--

UseCase07

@@ -22 +22 @@
 }}}
 
-''SELECT query за точка 3.''
+''UPDATE query за точка 3.''
 
 {{{#!sql:
@@ -30 +30 @@
 }}}
 
-''SELECT query за точка 4.''
+''UPDATE query за точка 4.''
 
 {{{#!sql:
@@ -38 +38 @@
 }}}
 
+''SELECT query за точка 6.''
+
+{{{#!sql:
+SELECT * FROM request WHERE status='Confirmed' AND confirmed_by_driver_id = (SELECT driver_id FROM driver WHERE first_name='Goce')
+}}}
+