Question: Consider the schema (tables/ documents) given bellow and write the SQL and NoSQL queries to find the appropriate answer student ( stu_id int primary key,

Consider the schema (tables/ documents) given bellow and write the SQL and NoSQL queries to find the appropriate answer student ( stu_id int primary key, stu_name string, stu_dept int, stu_gender string, stu_dis_id int) department ( dept_id int primary key, dept_title string) district ( dis_id int, dis name string) registration (crs_id string, stu_id int, sem id int) course (crs_id string primary key, crs_title string, crs_dept_id int) semester (sem id int primary key, sem_name string, sem_yrint) grade ( stu_id int, crs_id int, grade string, sem id) a) Count the total number of female student of "Barishal district b) Find the name of the students who have registered him/herself in Summer 2020 c) List the name of the Course(s) that has more than 40 registered students in a semester. d) List the name of the Student(s) who have taken a course at list twice e) List the name of the Course(s) that more than 5 "A+" in a Semester
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
