Write the queries of the tasks given below :Show the name of all users with the maximum multiplier among the developers whose number of followers is less than 700000. Find the average of number of followers but only consider the members who joined before 11 June 2020.Retrieve the member_ id, name, email, and followers of the developers who have either “.com” or “.net” in their email addresses. 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 : Show the name of all users with the maximum multiplier among the developers whose number of followers is less than 700000. Find the average of number of followers but only consider the members who joined before 11 June 2020. Retrieve the member_ id, name, email, and followers of the developers who have either “.com” or “.net” in their email addresses.

Write the queries of the tasks given below : Show the name of all users with the maximum multiplier among the developers whose number of followers is less than 700000. Find the average of number of followers but only consider the members who joined before 11 June 2020. Retrieve the member_ id, name, email, and followers of the developers who have either “.com” or “.net” in their email addresses.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a list of EMPNO, ENAME, HIREDATE, DEPTNO from EMPLOYEE for employee’s with a salary (SAL) greater than 2000. (Note: Do not print out the salary amount!) How many records were printed to the screen?
Using the results of the preceding command as a guide, compile a complete list of client purchases. You may sort the data by the invoice number, the customer code, and the product description. The INVOICE, LINE, and PRODUCT subscriptions are all required.
Write a php code to verify the add.employee form based on the following elements: also explain why we need both server and client side validation - All values must not be empty. - Gender values must be either male or female. - Name value must be alphabetic. -ID must be obtained from the department table.
Justify how a related subquery is executed in a certain order.
Create a procedure to allow company employee to add new product to the database. This procedure needs only IN parameters.
SQL find the Clients who have more than a total of 10,000$ combined in all the accounts they own. Retrieve their first names, last names, and the total balance in all the accounts they own. The output should be sorted chronogically on their date of births.
Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
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…
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Using the Categories, Subjects, and Classes tables, list the category description, SubjectID, SubjectCode, and SubjectName for all subject that are taught on Wednesdays. Do not list any subject more than once.
Determine the results of the below query. Explain how the result was calculated. SELECT TeamMember ID, SUM (Duration) FROM Task WHERE Duration > 1 GROUP BY TeamMember ID;