Course Name: Database Systems
Lab Homework 2
member_id name email followers joining_date multiplier
Write the queries of the tasks given below :
1. Show all the unique joining_date of the users joining in ascending order. [1]
2. Show the name and email of the developers who have the 5 highest numbers of followers. [2]
3. Count the number of developers in each multiplier. [2]
4. Show the name of all users with the maximum multiplier among the developers whose number of followers is less than 700000. [2]
6. Retrieve the member_ id, name, email and followers of the developers who have either “.com” or
“.net” in their email address. [1]
