Write a SQL query to find the member number (member_no) of each faculty whose department building is in 'Block_1' [Datab

[answerhappygod]

Write a SQL query to find the member number (member_no) of each
faculty whose department building is in 'Block_1' [Database: LIS]
lisdb:

Write A Sql Query To Find The Member Number Member No Of Each Faculty Whose Department Building Is In Block 1 Datab 1 (214.64 KiB) Viewed 16 times

book_issue member_no varchar(20) accession_no varchar(20) doi date book_copies ISBN_no varchar(13) accession_no varchar(20) staff staff_fname varchar(80) staff_lname varchar(80) id varchar(20) gender varchar(1) doj date mobile_no numeric(10) book_catalogue ISBN_no varchar(13) title varchar(256) publisher varchar(80) year int students student_fname varchar(80) student_iname varchar(80) roll_no varchar(20) department_code varchar(4) gender varchar(1) dob date degree varchar(80) mobile_no numeric(10) quota member_type varchar(2) max_books int max_duration int book_authors ISBN_no varchar(13) author_fname varchar(80) author_iname varchar(80) members member_no varchar(20) member_class varchar(20) member_type varchar(2) roll_no varchar(20) varchar(20) faculty faculty_fname varchar(80) faculty_Iname varchar(80) id varchar(20) department_code varchar(4) gender varchar(1) doj date mobile_no numeric/10) id departments department_code varchar(4) department_name varchar(80) department_building varchar(80)