write down the SQL queries., you can use join.

Student takes ID could MPC Monty jem guide Me depl_name bol_grad Section COM Id Bec_id advisor Come la title depr_name credits department dept_name builone budget year building room_wmder time_slot_ld fime_slot Ame_slot_id ead Aime prereg classroom Come la insiy chor ZD Powe departe mlary room_H2iber capacity teaches D cowe 30 Seed semester 1827 1. Students, who know Shankar from course(s) 2. Students who attend courses which also Tanaka attends. 3. All students with their names and number of courses they attend 4. Average number of lectures per student