student_club Database Schema

SQL Query:

SELECT T1.zip FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T2.cost < 50

Evidence:

incurred less than 50USD refers to cost < 50

SQL Query:

SELECT T1.event_name FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event GROUP BY T1.event_id HAVING COUNT(T2.link_to_event) > 20 EXCEPT SELECT T1.event_name FROM event AS T1  WHERE T1.type = 'Fundraiser'

Evidence:

name of events refers to event_name; attendance of over 20 students COUNT(event_id) > 20.

SQL Query:

SELECT COUNT(T2.link_to_member) FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'Community Theater' AND SUBSTR(T1.event_date, 1, 4) = '2019'

Evidence:

event 'Community Theater' in 2019 refers to event_name = 'Community Theater' where YEAR(event_date) = 2019

SQL Query:

SELECT T2.college FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T1.first_name = 'Tyler' AND T1.last_name = 'Hewitt'

SQL Query:

SELECT first_name, last_name, email FROM member WHERE position = 'Secretary'

Evidence:

full name refers to first_name, last_name; 'Secretary' is a position of Student Club