Show all the unique joining_date of the users joining in ascending order. Show the name and email of the developers who have the 5 highest numbers of followers. Count the number of developers in each multiplier.
Show all the unique joining_date of the users joining in ascending order. Show the name and email of the developers who have the 5 highest numbers of followers. Count the number of developers in each multiplier.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 3.11CP
Related questions
Question
100%
Write the queries of the tasks given below :
- Show all the unique joining_date of the users joining in ascending order.
- Show the name and email of the developers who have the 5 highest numbers of followers.
- Count the number of developers in each multiplier.
![Soon after joining Google's elite dev team, Area 120, you were assigned to a project using MySQL since
it was your specialty. The project was a social media platform specialized in allowing developers from all
over the globe to connect to each other, and it would have features similar to Facebook. For your first
task, you have been assigned to work on the tables of one of the project databases. The table name is
"Developers" which is shown below.
member_id
1
2
3
5
6
7
8
9
10
11
12
name
Taylor Otwell
Ryan Dahl
Brendan Eich
Evan You
Rasmus Lerdorf
Guido van Rossum
Adrian Holovaty
Simon Willison
James Gosling
Rod Johnson
Satoshi Nakamoto
email
otwell@laravel.com
ryan@nodejs.org
eich@javascript.com
you@vuejs.org
lerdorf@php.net
guido@python.org
adrian@djangoproject.com
simon@djangoproject.com
james@java.com
rod@spring.io
nakamoto@blockchain.com
followers
739360
633632
939570
982630
937927
968827
570724
864615
719491
601744
630488
joining_date
2020-6-10
2020-04-22
2020-05-07
2020-06-11
2020-06-3
2020-07-18
2020-05-07
2020-04-30
2020-05-18
2020-05-18
2020-05-10
multiplier
10
10
8
7
8
19
5
4
5
7
10](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F83c13de9-775f-43a6-a34c-0ec7e6de8b0b%2F1cc4aa60-ad1d-460f-b193-2daee838bd59%2Fbb4uxcd_processed.png&w=3840&q=75)
Transcribed Image Text:Soon after joining Google's elite dev team, Area 120, you were assigned to a project using MySQL since
it was your specialty. The project was a social media platform specialized in allowing developers from all
over the globe to connect to each other, and it would have features similar to Facebook. For your first
task, you have been assigned to work on the tables of one of the project databases. The table name is
"Developers" which is shown below.
member_id
1
2
3
5
6
7
8
9
10
11
12
name
Taylor Otwell
Ryan Dahl
Brendan Eich
Evan You
Rasmus Lerdorf
Guido van Rossum
Adrian Holovaty
Simon Willison
James Gosling
Rod Johnson
Satoshi Nakamoto
email
otwell@laravel.com
ryan@nodejs.org
eich@javascript.com
you@vuejs.org
lerdorf@php.net
guido@python.org
adrian@djangoproject.com
simon@djangoproject.com
james@java.com
rod@spring.io
nakamoto@blockchain.com
followers
739360
633632
939570
982630
937927
968827
570724
864615
719491
601744
630488
joining_date
2020-6-10
2020-04-22
2020-05-07
2020-06-11
2020-06-3
2020-07-18
2020-05-07
2020-04-30
2020-05-18
2020-05-18
2020-05-10
multiplier
10
10
8
7
8
19
5
4
5
7
10
![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]
5. Find the average of the number of followers but only consider the members who joined before 11
June 2020. [2]
6. Retrieve the member_id, name, email and followers of the developers who have either ".com" or
".net" in their email address. [1]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F83c13de9-775f-43a6-a34c-0ec7e6de8b0b%2F1cc4aa60-ad1d-460f-b193-2daee838bd59%2Fgbg5rq_processed.png&w=3840&q=75)
Transcribed Image Text: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]
5. Find the average of the number of followers but only consider the members who joined before 11
June 2020. [2]
6. Retrieve the member_id, name, email and followers of the developers who have either ".com" or
".net" in their email address. [1]
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Similar questions
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L