InitHEADmain

1 files changed, 27 insertions, 0 deletions

diff --git a/Homework/cs5800/Exams/2.study b/Homework/cs5800/Exams/2.study
new file mode 100644
index 0000000..8616d0c
--- /dev/null
+++ b/Homework/cs5800/Exams/2.study
@@ -0,0 +1,27 @@
+delimiter //
+create procedure get_user_deets3(in u_ssn varchar(9), out u_email varchar(64), out u_type varchar(64), out u_name varchar(64)) 
+begin 
+  if u_ssn in (select ssn from user)
+  then
+    select email, type, name
+    into u_email, u_type, u_name
+    from user where ssn=u_ssn;
+  end if;
+end //
+
+delimiter ; 
+
+
+
+delimiter //
+create function before_date (start date)
+returns integer deterministic
+begin
+declare count_before_date integer;
+select count(*) into count_before_date
+from reservation
+where date < start;
+return count_before_date;
+end //
+delimiter ;
+