276
Приложение C
| 4 | Susan | Hawthorne | Headquarters |
| 5 | John | Gooding | Headquarters |
| 6 | Helen | Fleming | Headquarters |
| 7 | Chris | Tucker | Headquarters |
| 8 | Sarah | Parker | Headquarters |
| 9 | Jane | Grossman | Headquarters |
| 10 | Paula | Roberts | Woburn Branch |
| 11 | Thomas | Ziegler | Woburn Branch |
| 12 | Samantha | Jameson | Woburn Branch |
| 13 | John | Blake | Quincy Branch |
| 14 | Cindy | Mason | Quincy Branch |
| 15 | Frank | Portman | Quincy Branch |
| 16 | Theresa | Markham | So. NH Branch |
| 17 | Beth | Fowler | So. NH Branch |
| 18 | Rick | Tulman | So. NH Branch |
+++++
18 rows in set (0.03 sec)
Верные значения для
<1>
и
<2>
:
1.
branch
2.
branch_id
5.2
Напишите запрос, по которому для каждого клиентафизического лица
(
customer.cust_type_cd
=
'I'
) возвращаются ID счета, федеральный ID
(
customer.fed_id
) и тип созданного счета (
product.name
).
mysql>
2>1>2>1>3>2>1>3>2>1>
Достарыңызбен бөлісу: