member_id name email influence_count Joining_date multiplier
Write the queries of the tasks given below [5 X 2 = 10].
1. Create the above table with appropriate data type for each column
2. Change the column name “influence_count”. The new name should be “followers” and the data type should be integer.
3. Update the number of followers of each developer by +10.
4. Show the name, email, and follower number of the developers.
5. There is a formula to find the efficiency of the developers.
Efficiency = ((followers*100/1000000) * (multipliers*100/20))/100.
Show the efficiency of each developer in a column named “Efficiency” along with their name.
