30. Extract all orders of Miti.

select
    *
from
    orders
where
    snum = (
        select
            snum
        from
            salesman
        where
            sname = 'Miti'
    );

Output: