Aggregation examples - Aggregation For this exercise,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Aggregation For this exercise, let’s create and populate the employees table. drop table employees; create table employees ( id integer PRIMARY KEY, fname varchar (10), lname varchar (15), title varchar (15), salary number, departmentID number ); insert into employees (id, fname, lname, title, salary, departmentID) values (1, 'Yelena', 'Bytenskaya', 'Instructor', 50000, 1); insert into employees (id, fname, lname, title, salary, departmentID) values (2, 'Mary', 'Artis', 'Writer', 49000, 1); insert into employees (id, fname, lname, title, salary, departmentID) values (3, 'Neal', 'Burks', 'Writer', 45000, 1); insert into employees (id, fname, lname, title, salary, departmentID) values (4, 'Larissa', 'Campbell', 'DBA', 80000, 2); insert into employees (id, fname, lname, title, salary, departmentID) values (5, 'Sean', 'Jensen', 'DBA', 65000, 1); insert into employees (id, fname, lname, title, salary, departmentID)...
View Full Document

This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Page1 / 7

Aggregation examples - Aggregation For this exercise,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online