From 6bf4b90c90f15f4ab60833bddf5b5756d1a6b1f6 Mon Sep 17 00:00:00 2001
From: Elizabeth Alexander Hunt <me@liz.coffee>
Date: Thu, 2 Jul 2026 11:55:17 -0700
Subject: Init

---
 Homework/cs5800/Exams/2.study | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 Homework/cs5800/Exams/2.study

(limited to 'Homework/cs5800/Exams/2.study')

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 ;
+
-- 
cgit v1.3