LIST Software interview question

sql queries to fetch data from 2 tables