N X MySQLWorkbench File Edit View O This web page was reloaded Account Dashboard Courses 28...

Transcribed Image Text:

N X MySQLWorkbench File Edit View O This web page was reloaded Account Dashboard Courses 28 Groups Calendar Inbox History (?) Help D 1 D 2 3 4 D 5 6 D 7 8 < D 9 O LO 5 6 Administration SCHEMAS Q employees > > > > > > Tables Query Database Server Local instance 3306 DEC 4 departments dept_emp salaries titles 1 7 8 4 dept_manager employees Columns Indexes Foreign Keys Triggers Query interrupted Schemas Views Stored Procedures Object Info No object selected Functions Showing loaded schemas only Session V R X SQL File 4 O 100% Result Grid dept_no d009 d005 d002 d003 d001 d004 |d006 d008 d007 NULL Tools Scripting Help 1. SELECT * FROM employees. departments; 2 Action Output 1:2 departments 8 employees Time 159 13:42:16 * 160 13:42:16 Filter Rows: Q Search dept_name Customer Service Development Finance Human Resources Marketing Production dept_emp Quality Management Research Sale NULL ). tv dept_manager 5 MySQL Workbench Limit to 2000 rows Edit: zoom departments Q Action SELECT * FROM employees.salaries LIMIT 0, 2000 SELECT MAX(salary), first_name, last_name FROM employees, departments, salaries W... Export/Import: ())) 1 departments W H 4 7 ? salaries ((. PC Sun Dec 4 1:42 PM Response 2000 row(s) returned Error Code: 1140. In aggregated query without GROU... aaaaaaa Apply Duration / Fetc 0.0074 sec / 0.C 0.0038 sec MYSQLWorkbench Project Part 2: IS Fall 2022 Home Zoom Announcem Syllabus Modules Discussions Grades SOTE People Assignments 000 Administration SCHEMAS Qemployees > > > > File Edit View Query Database Server Tools Scripting Help employees Tables > Columns: Views Local instance 3306 departments dept_emp dept_manager employees salaries titles Object Info Table: departments JA I 40 current_dept_emp emp_no dept_no from_date to date Showing loaded schemas only Schemas Query Completed O dept_no char(4) PK dept_name varchar(40) Session DEC 4 X SQL File 4 100% Result Grid emp_no 1. SELECT * FROM employees.current_dept_emp; 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 Action Output 665 42:1 current_dept_emp 1 3 d005 |d007 d004 |d004 d003 d005 |d008 |d005 d006 d006 d009 d005 |d003 Time dept_no from_date 1986-06-26 1996-08-03 1995-12-03 1986-12-01 1989-09-12 1990-08-05 1989-02-10 1998-03-11 1985-02-18 2000-06-26 1990-01-22 1992-12-18 1985-10-20 10.32.12 * 400 18:32:12 * 401 18:32:50 * 402 18:33:00 403 18:33:15 employees LIT Filter Rows: dept_emp Q Search MYSQL Workbench dept_manager Limit to 2000 rows to_date 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 |9999-01-01 2000-07-31 9999-01-01 9999-01-01 1996-11-09 9999-01-01 9999-01-01 IT DE Export: BU departments 5 tv A Fetch rows: Action SELECT * FROM employees.departments LIMIT 0, 2000 SELECT first_name, last_name FROM employees WHERE employees.departments IN (... SELECT E.first_name, E.last_name, d.department FROM employees.employees E LIMIT... SELECT E.first_name, E.last_name, D.department FROM employees.employees E LIMIT... SELECT * FROM employees.departments LIMIT 0, 2000 zoom departments Q + W salaries Response Tow(S) returned 32 ? departments Error Code: 1054. Unknown column 'employees.depar... Error Code: 1054. Unknown column 'd.department' in... Error Code: 1054. Unknown column 'D.department' in... 9 row(s) returned m PC Sun Dec 4 6:36 PM current_dept_emp =-=- | Result Grid Form Editor Field Types Read Only Duration / Fetch Time 0.0034 sec / 0.000UZ... 0.0019 sec 0.00045 sec 0.00038 sec 0.00050 sec / 0.0000... ID N X MySQLWorkbench File Edit View O This web page was reloaded Account Dashboard Courses 28 Groups Calendar Inbox History (?) Help D 1 D 2 3 4 D 5 6 D 7 8 < D 9 O LO 5 6 Administration SCHEMAS Q employees > > > > > > Tables Query Database Server Local instance 3306 DEC 4 departments dept_emp salaries titles 1 7 8 4 dept_manager employees Columns Indexes Foreign Keys Triggers Query interrupted Schemas Views Stored Procedures Object Info No object selected Functions Showing loaded schemas only Session V R X SQL File 4 O 100% Result Grid dept_no d009 d005 d002 d003 d001 d004 |d006 d008 d007 NULL Tools Scripting Help 1. SELECT * FROM employees. departments; 2 Action Output 1:2 departments 8 employees Time 159 13:42:16 * 160 13:42:16 Filter Rows: Q Search dept_name Customer Service Development Finance Human Resources Marketing Production dept_emp Quality Management Research Sale NULL ). tv dept_manager 5 MySQL Workbench Limit to 2000 rows Edit: zoom departments Q Action SELECT * FROM employees.salaries LIMIT 0, 2000 SELECT MAX(salary), first_name, last_name FROM employees, departments, salaries W... Export/Import: ())) 1 departments W H 4 7 ? salaries ((. PC Sun Dec 4 1:42 PM Response 2000 row(s) returned Error Code: 1140. In aggregated query without GROU... aaaaaaa Apply Duration / Fetc 0.0074 sec / 0.C 0.0038 sec N X MySQLWorkbench File Edit View O This web page was reloaded Account Dashboard Courses 28 Groups Calendar Inbox History (?) Help D 1 D 2 3 4 D 5 6 D 7 8 < D 9 O LO 5 6 Administration SCHEMAS Q employees > > > > > > Tables Query Database Server Local instance 3306 DEC 4 departments dept_emp salaries titles 1 7 8 4 dept_manager employees Columns Indexes Foreign Keys Triggers Query interrupted Schemas Views Stored Procedures Object Info No object selected Functions Showing loaded schemas only Session V R X SQL File 4 O 100% Result Grid dept_no d009 d005 d002 d003 d001 d004 |d006 d008 d007 NULL Tools Scripting Help 1. SELECT * FROM employees. departments; 2 Action Output 1:2 departments 8 employees Time 159 13:42:16 * 160 13:42:16 Filter Rows: Q Search dept_name Customer Service Development Finance Human Resources Marketing Production dept_emp Quality Management Research Sale NULL ). tv dept_manager 5 MySQL Workbench Limit to 2000 rows Edit: zoom departments Q Action SELECT * FROM employees.salaries LIMIT 0, 2000 SELECT MAX(salary), first_name, last_name FROM employees, departments, salaries W... Export/Import: ())) 1 departments W H 4 7 ? salaries ((. PC Sun Dec 4 1:42 PM Response 2000 row(s) returned Error Code: 1140. In aggregated query without GROU... aaaaaaa Apply Duration / Fetc 0.0074 sec / 0.C 0.0038 sec N X MySQLWorkbench File Edit View O This web page was reloaded Account Dashboard Courses 28 Groups Calendar Inbox History (?) Help D 1 D 2 3 4 D 5 6 D 7 8 < D 9 O LO 5 6 Administration SCHEMAS Q employees > > > > > > Tables Query Database Server Local instance 3306 DEC 4 departments dept_emp salaries titles 1 7 8 4 dept_manager employees Columns Indexes Foreign Keys Triggers Query interrupted Schemas Views Stored Procedures Object Info No object selected Functions Showing loaded schemas only Session V R X SQL File 4 O 100% Result Grid dept_no d009 d005 d002 d003 d001 d004 |d006 d008 d007 NULL Tools Scripting Help 1. SELECT * FROM employees. departments; 2 Action Output 1:2 departments 8 employees Time 159 13:42:16 * 160 13:42:16 Filter Rows: Q Search dept_name Customer Service Development Finance Human Resources Marketing Production dept_emp Quality Management Research Sale NULL ). tv dept_manager 5 MySQL Workbench Limit to 2000 rows Edit: zoom departments Q Action SELECT * FROM employees.salaries LIMIT 0, 2000 SELECT MAX(salary), first_name, last_name FROM employees, departments, salaries W... Export/Import: ())) 1 departments W H 4 7 ? salaries ((. PC Sun Dec 4 1:42 PM Response 2000 row(s) returned Error Code: 1140. In aggregated query without GROU... aaaaaaa Apply Duration / Fetc 0.0074 sec / 0.C 0.0038 sec MYSQLWorkbench Project Part 2: IS Fall 2022 Home Zoom Announcem Syllabus Modules Discussions Grades SOTE People Assignments 000 Administration SCHEMAS Qemployees > > > > File Edit View Query Database Server Tools Scripting Help employees Tables > Columns: Views Local instance 3306 departments dept_emp dept_manager employees salaries titles Object Info Table: departments JA I 40 current_dept_emp emp_no dept_no from_date to date Showing loaded schemas only Schemas Query Completed O dept_no char(4) PK dept_name varchar(40) Session DEC 4 X SQL File 4 100% Result Grid emp_no 1. SELECT * FROM employees.current_dept_emp; 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 Action Output 665 42:1 current_dept_emp 1 3 d005 |d007 d004 |d004 d003 d005 |d008 |d005 d006 d006 d009 d005 |d003 Time dept_no from_date 1986-06-26 1996-08-03 1995-12-03 1986-12-01 1989-09-12 1990-08-05 1989-02-10 1998-03-11 1985-02-18 2000-06-26 1990-01-22 1992-12-18 1985-10-20 10.32.12 * 400 18:32:12 * 401 18:32:50 * 402 18:33:00 403 18:33:15 employees LIT Filter Rows: dept_emp Q Search MYSQL Workbench dept_manager Limit to 2000 rows to_date 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 |9999-01-01 2000-07-31 9999-01-01 9999-01-01 1996-11-09 9999-01-01 9999-01-01 IT DE Export: BU departments 5 tv A Fetch rows: Action SELECT * FROM employees.departments LIMIT 0, 2000 SELECT first_name, last_name FROM employees WHERE employees.departments IN (... SELECT E.first_name, E.last_name, d.department FROM employees.employees E LIMIT... SELECT E.first_name, E.last_name, D.department FROM employees.employees E LIMIT... SELECT * FROM employees.departments LIMIT 0, 2000 zoom departments Q + W salaries Response Tow(S) returned 32 ? departments Error Code: 1054. Unknown column 'employees.depar... Error Code: 1054. Unknown column 'd.department' in... Error Code: 1054. Unknown column 'D.department' in... 9 row(s) returned m PC Sun Dec 4 6:36 PM current_dept_emp =-=- | Result Grid Form Editor Field Types Read Only Duration / Fetch Time 0.0034 sec / 0.000UZ... 0.0019 sec 0.00045 sec 0.00038 sec 0.00050 sec / 0.0000... ID MYSQLWorkbench Project Part 2: IS Fall 2022 Home Zoom Announcem Syllabus Modules Discussions Grades SOTE People Assignments 000 Administration SCHEMAS Qemployees > > > > File Edit View Query Database Server Tools Scripting Help employees Tables > Columns: Views Local instance 3306 departments dept_emp dept_manager employees salaries titles Object Info Table: departments JA I 40 current_dept_emp emp_no dept_no from_date to date Showing loaded schemas only Schemas Query Completed O dept_no char(4) PK dept_name varchar(40) Session DEC 4 X SQL File 4 100% Result Grid emp_no 1. SELECT * FROM employees.current_dept_emp; 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 Action Output 665 42:1 current_dept_emp 1 3 d005 |d007 d004 |d004 d003 d005 |d008 |d005 d006 d006 d009 d005 |d003 Time dept_no from_date 1986-06-26 1996-08-03 1995-12-03 1986-12-01 1989-09-12 1990-08-05 1989-02-10 1998-03-11 1985-02-18 2000-06-26 1990-01-22 1992-12-18 1985-10-20 10.32.12 * 400 18:32:12 * 401 18:32:50 * 402 18:33:00 403 18:33:15 employees LIT Filter Rows: dept_emp Q Search MYSQL Workbench dept_manager Limit to 2000 rows to_date 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 |9999-01-01 2000-07-31 9999-01-01 9999-01-01 1996-11-09 9999-01-01 9999-01-01 IT DE Export: BU departments 5 tv A Fetch rows: Action SELECT * FROM employees.departments LIMIT 0, 2000 SELECT first_name, last_name FROM employees WHERE employees.departments IN (... SELECT E.first_name, E.last_name, d.department FROM employees.employees E LIMIT... SELECT E.first_name, E.last_name, D.department FROM employees.employees E LIMIT... SELECT * FROM employees.departments LIMIT 0, 2000 zoom departments Q + W salaries Response Tow(S) returned 32 ? departments Error Code: 1054. Unknown column 'employees.depar... Error Code: 1054. Unknown column 'd.department' in... Error Code: 1054. Unknown column 'D.department' in... 9 row(s) returned m PC Sun Dec 4 6:36 PM current_dept_emp =-=- | Result Grid Form Editor Field Types Read Only Duration / Fetch Time 0.0034 sec / 0.000UZ... 0.0019 sec 0.00045 sec 0.00038 sec 0.00050 sec / 0.0000... ID MYSQLWorkbench Project Part 2: IS Fall 2022 Home Zoom Announcem Syllabus Modules Discussions Grades SOTE People Assignments 000 Administration SCHEMAS Qemployees > > > > File Edit View Query Database Server Tools Scripting Help employees Tables > Columns: Views Local instance 3306 departments dept_emp dept_manager employees salaries titles Object Info Table: departments JA I 40 current_dept_emp emp_no dept_no from_date to date Showing loaded schemas only Schemas Query Completed O dept_no char(4) PK dept_name varchar(40) Session DEC 4 X SQL File 4 100% Result Grid emp_no 1. SELECT * FROM employees.current_dept_emp; 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 Action Output 665 42:1 current_dept_emp 1 3 d005 |d007 d004 |d004 d003 d005 |d008 |d005 d006 d006 d009 d005 |d003 Time dept_no from_date 1986-06-26 1996-08-03 1995-12-03 1986-12-01 1989-09-12 1990-08-05 1989-02-10 1998-03-11 1985-02-18 2000-06-26 1990-01-22 1992-12-18 1985-10-20 10.32.12 * 400 18:32:12 * 401 18:32:50 * 402 18:33:00 403 18:33:15 employees LIT Filter Rows: dept_emp Q Search MYSQL Workbench dept_manager Limit to 2000 rows to_date 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 9999-01-01 |9999-01-01 2000-07-31 9999-01-01 9999-01-01 1996-11-09 9999-01-01 9999-01-01 IT DE Export: BU departments 5 tv A Fetch rows: Action SELECT * FROM employees.departments LIMIT 0, 2000 SELECT first_name, last_name FROM employees WHERE employees.departments IN (... SELECT E.first_name, E.last_name, d.department FROM employees.employees E LIMIT... SELECT E.first_name, E.last_name, D.department FROM employees.employees E LIMIT... SELECT * FROM employees.departments LIMIT 0, 2000 zoom departments Q + W salaries Response Tow(S) returned 32 ? departments Error Code: 1054. Unknown column 'employees.depar... Error Code: 1054. Unknown column 'd.department' in... Error Code: 1054. Unknown column 'D.department' in... 9 row(s) returned m PC Sun Dec 4 6:36 PM current_dept_emp =-=- | Result Grid Form Editor Field Types Read Only Duration / Fetch Time 0.0034 sec / 0.000UZ... 0.0019 sec 0.00045 sec 0.00038 sec 0.00050 sec / 0.0000... ID