Type your query or get one at random
+------+-------+---------+--------+-----------------+ | :sid | :name | :status | :city | :supplying | +------+-------+---------+--------+-----------------+ | S1 | Smith | 20 | London | +------+------+ | | | | | | | :pid | :qty | | | | | | | +------+------+ | | | | | | | P1 | 300 | | | | | | | | P2 | 200 | | | | | | | | P3 | 400 | | | | | | | | P4 | 200 | | | | | | | | P5 | 100 | | | | | | | | P6 | 100 | | | | | | | +------+------+ | | S2 | Jones | 10 | Paris | +------+------+ | | | | | | | :pid | :qty | | | | | | | +------+------+ | | | | | | | P1 | 300 | | | | | | | | P2 | 400 | | | | | | | +------+------+ | | S3 | Blake | 30 | Paris | +------+------+ | | | | | | | :pid | :qty | | | | | | | +------+------+ | | | | | | | P2 | 200 | | | | | | | +------+------+ | | S4 | Clark | 20 | London | +------+------+ | | | | | | | :pid | :qty | | | | | | | +------+------+ | | | | | | | P2 | 200 | | | | | | | | P4 | 300 | | | | | | | | P5 | 400 | | | | | | | +------+------+ | | S5 | Adams | 30 | Athens | [] | +------+-------+---------+--------+-----------------+