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 sinceit was your specialty. The project was a social media platform specialized in allowing developers from allover the globe to connect to each other, and it would have features similar to Facebook. For your firsttask, 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_id12356789101112nameTaylor OtwellRyan DahlBrendan EichEvan YouRasmus LerdorfGuido van RossumAdrian HolovatySimon WillisonJames GoslingRod JohnsonSatoshi Nakamotoemailotwell@laravel.comryan@nodejs.orgeich@javascript.comyou@vuejs.orglerdorf@php.netguido@python.orgadrian@djangoproject.comsimon@djangoproject.comjames@java.comrod@spring.ionakamoto@blockchain.comfollowers739360633632939570982630937927968827570724864615719491601744630488joining_date2020-6-102020-04-222020-05-072020-06-112020-06-32020-07-182020-05-072020-04-302020-05-182020-05-182020-05-10multiplier101087819545710 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 offollowers is less than 700000. [2]5. Find the average of the number of followers but only consider the members who joined before 11June 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]

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.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 3.11CP

See similar textbooks

Similar questions

The International Conference on Mathematical Sciences and Technology, MathTech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation () to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and return…
Visual Studio produces Personnel.mdf. A database table called "Employee" need to include the employee ID, name, position, and hourly pay rate of each worker. The employee ID serves as the primary key. It would be helpful to have five example rows in the Employee table. The Employee table may be seen in a DataGridView inside an application.
Develop a Use Case Diagram for the below description: "The online committee setup application allows section head to create a committee by entering committee name and objectives and selecting members from a drop-down menu. The committee chairperson will use the application to call for a committee meeting by deciding on start/ end date, start/end time and list of attendants. Once the meeting is held the committee chairperson will upload the meeting minutes to the application. Meeting attendants can view the minutes of the meeting and approve its content or send a request to amend the minutes as an email. The meeting attendants can use the application to view other attendants' profiles including logo, personal image and then send them an email, as well as respond to emails sent to them. The committee chairperson can also use the same functionalities of attendants". Instructions and Notes: - Use Online Visual Paradigm to produce your use case diagram. Visual Paradigm Online…
Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task Retrieve the mailing address (first name, surname, and address) for each resident. Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT. Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task Add Yigit…
Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS. Provide the StayWell team the number of gifts for each office. Provide the StayWell team the number of gifts for each residence.
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS.
NOTE: If you choose this project you need to prepare/submit SRS and design document. Online Lecture Scheduling Application Project Domain/Category: Web application. Abstract/Introduction This application will generate the schedule of lectures for the courses being offered in a semester of an educational institute. Usually, for every semester, a lecture schedule is manually developed keeping in view the students enrolled in different courses, faculty members teaching those courses, and classrooms or labs where those lectures are delivered. It is also considered that if a student is enrolled in more than one courses, then those courses must not be scheduled on the same day same time. Same is the case with a faculty member teaching more than one courses. Similarly, a classroom or lab cannot be used for scheduling more than one courses on same day same time. In order to generate the lecture schedule, user will be required to provide list of offered courses, list of students enrolled…
The SERVICE_REQUEST table uses the CHAR data type for the DESCRIPTION and STATUS fields. Is there an alternate data type that could be used to store the values in these fields? Justify your reason for choosing an alternate data type or for leaving the data type as CHAR.
Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.
Layout References Mailings Review View Developer Help KOD RENT_CH Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the orientation of the ERD components.) FIGURE P2.15 The Crow's Foot ERD for Problem 19 PUBLISHER BOOK publishes sub mits writes CONTRACT AUTHOR signs 十 A business rule is an explanation that forces some type of requirement on a particular part of the information base, like the components inside a field detail for a specific field or the attributes of a given relationship. tes) EO * Accessibility: Investigate DE 26 bp
The Driver Relationship team also requests the joining dates of the drivers to create a timeline. In the table, you only need to return the joining date of the drivers. You need to only return the DRIVER_START_DATE column inside a SELECT statement for the DRIVERS table.