student_club Database Schema

SQL Query:

SELECT T1.first_name, T1.last_name, T1.position FROM member AS T1 INNER JOIN zip_code AS T2 ON T2.zip_code = T1.zip WHERE T2.city = 'Lincolnton' AND T2.state = 'North Carolina' AND T2.zip_code = 28092

Evidence:

full name refers to first_name, last_name, hometown of Lincolnton, North Carolina refers to city = 'Lincolnton' AND state = 'North Carolina'

SQL Query:

SELECT DISTINCT T2.category FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.location = 'MU 215'

Evidence:

'MU 215' is the location of event;

SQL Query:

SELECT T2.position FROM major AS T1 INNER JOIN member AS T2 ON T1.major_id = T2.link_to_major WHERE T1.major_name = 'Business'

Evidence:

'Business' is the major name

SQL Query:

SELECT SUM(spent) FROM budget WHERE category = 'Food'

Evidence:

total amount of money spent refers to SUM(spent); spent for food refers to category = 'Food'

SQL Query:

SELECT T1.first_name, T1.last_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T2.department = 'School of Applied Sciences, Technology and Education'

Evidence:

list all members means to list all the full name; full name refers to first_name, last_name;