Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Provide MySQL output screenshots for the following queries. They are numbered 1-6

Provide MySQL output screenshots for the following queries. They are numbered 1-6

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
Provide MySQL output screenshots for the following queries. They are numbered 1-6
1> part1 create table employee ( EmpNo int, Ename varchar(255), Department varchar(255), Salary int ); this statement will create table employee with stated columns 1> part2 insert into employee ( EmpNo, Ename, Department, Salary) values ( 001, 'Levina', 'Developer',10000 ),(002, 'Levin', 'Programmer, 15000), ( 003, 'Liviya', 'Analyst,20000 ), ( 004, 'Johanna', "Testing', 10000 ), ( 005, 'Johan', 'Developer',15000 ), ( 006, 'Jino', 'Admin',25000 ), ( 007, 'Jeno', 'Admin',25000 ), ( 008, 'Prabin', 'Analyst,15000 );
Transcribed Image Text:1> part1 create table employee ( EmpNo int, Ename varchar(255), Department varchar(255), Salary int ); this statement will create table employee with stated columns 1> part2 insert into employee ( EmpNo, Ename, Department, Salary) values ( 001, 'Levina', 'Developer',10000 ),(002, 'Levin', 'Programmer, 15000), ( 003, 'Liviya', 'Analyst,20000 ), ( 004, 'Johanna', "Testing', 10000 ), ( 005, 'Johan', 'Developer',15000 ), ( 006, 'Jino', 'Admin',25000 ), ( 007, 'Jeno', 'Admin',25000 ), ( 008, 'Prabin', 'Analyst,15000 );
2> alter table employee modify column Empno int(6); 3> select * from employee where Salary between O and 10000; it will print all empolyee betweeen salary range 0 to 10000 4> select Ename from employee where Ename like jo%; this above query will sort only names starting with jo 5> select avg(Salary) from employee; this will print average salary of employee 6> select * from employee order by Salary desc; order by will order the output in descending order
Transcribed Image Text:2> alter table employee modify column Empno int(6); 3> select * from employee where Salary between O and 10000; it will print all empolyee betweeen salary range 0 to 10000 4> select Ename from employee where Ename like jo%; this above query will sort only names starting with jo 5> select avg(Salary) from employee; this will print average salary of employee 6> select * from employee order by Salary desc; order by will order the output in descending order
Expert Solution
1> Part 1

Computer Engineering homework question answer, step 1, image 1

steps

Step by step

Solved in 7 steps with 7 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