";
$query1 = 'select * from department';
$query2 = 'select * from department where dnumber = 6';
$query3 = 'select * from employee';
$query4 = 'select fname, lname, ssn, bdate, sex, salary, super_ssn, dno
from employee';
$query5 = '
select e.fname, e.lname, d.dname as dept, s.lname as boss
from employee e join department d on e.dno = d.dnumber
left join employee s on e.super_ssn = s.ssn';
$query6 = '
select e.fname, e.lname, p.pname, w.hours, p.plocation
from employee e, project p, works_on w
where e.ssn = w.essn and p.pnumber = w.pno
order by e.lname'
;
$query = $query6;
print "demo query
";
print "\n";
$queryres = $dbconn->query($query);
table_format_pdo($queryres);
print "