oracle - Two Table SQL review -
a pic of tables above.
- list youngest customer.
- list orders (ordereid, order date, amount) along customer details.
i struggling these 2 questions.
can't see table name pic?
list youngest customer. try replact [top table pic] name of actual table.
select custfname, custlname, min(date) (select *, cast(dateofbirth date) date customers) group 1,2;
or
select top 1 * customers order dateofbirth asc
4.list orders (ordereid, order date, amount) along customer details.
select a.*, b.custlname, b.custfname, b.dateofbirth, b.custcity orders left join customers b on b.custid = a.custid
Comments
Post a Comment