Write SQL query to find sum of marks of all the students in the table: Class1(RollNo, Names, Marks)

Question: Which colleges offer courses?    (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE;

#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.

Consider the following table: Instructors ID 12121 15151 22222 32343 33456 name Alice Wu John Mozart Frank Einstein El Said Chelsea Dunn deptName Finances Music Physics History Physics salary 90000.00 40000.00 95000.00 60000.00 90000.00 Write a single SQL query to list in descending order the deptNames and names of all instructors. Note that every column of Instructors should be included in the result.