Coursera数据相关面经_Coursera数据相关面试真题及高频题

1.Calculate the Proportion of Users Registered but Not Enrolled in Any Course

2.SQL Query to Find Courses Not Offered in a Specific Country

1. Calculate the Proportion of Users Registered but Not Enrolled in Any Course

Write an SQL query to calculate the proportion of users who are registered but have not enrolled in any course. You will need to perform aggregation before calculating the proportion.

2. SQL Query to Find Courses Not Offered in a Specific Country

Write an SQL query to find all courses that are not offered in a specific country. This will require a JOIN operation between two tables.