Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v.n,s.m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month "April". Count the number of users for each TLD (TLD is the last part of the email after the dot).

Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v.n,s.m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month "April". Count the number of users for each TLD (TLD is the last part of the email after the dot).

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
PROBLEM -1 The table name is "users" and its structure is shown below. You can insert as many rows in your database as you want to check your queries. ID int Name varchar(100) Email varchar(50) Influence_count int Member_since date Multiplier int Task Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v,n,s,m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month "April". Count the number of users for each TLD (TLD is the last part of the email after the dot). Sample data in the table can be - (you should add more rows to check the outputs for all the tasks) 1 Taylor Otwell otwell@laravel.com 739360 2020-6-10 10 2 Ryan Dahl ryan@nodejs.org 633632 2020-04-22 10 Evan You you@vuejs.org 982630 2020-06-11 7 Brendan Eich eich@javascript.com 939570 2020-05-07 8 Rasmus Lerdorf lerdorf@php.net 937927 2020-06-3 8 3.
Transcribed Image Text:PROBLEM -1 The table name is "users" and its structure is shown below. You can insert as many rows in your database as you want to check your queries. ID int Name varchar(100) Email varchar(50) Influence_count int Member_since date Multiplier int Task Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v,n,s,m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month "April". Count the number of users for each TLD (TLD is the last part of the email after the dot). Sample data in the table can be - (you should add more rows to check the outputs for all the tasks) 1 Taylor Otwell otwell@laravel.com 739360 2020-6-10 10 2 Ryan Dahl ryan@nodejs.org 633632 2020-04-22 10 Evan You you@vuejs.org 982630 2020-06-11 7 Brendan Eich eich@javascript.com 939570 2020-05-07 8 Rasmus Lerdorf lerdorf@php.net 937927 2020-06-3 8 3.
Expert Solution
steps

Step by step

Solved in 5 steps with 13 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS