請問各大大以下2個的SQL語法要如何下,謝謝!!
環境 : Postgre SQL    1.列出BB Table的value都為T的AA Table的mid及name
結果如:
mid name
=== ====
 2   B
 4   D    2.列出BB Table的value為T及F的出現次數
結果如:
mid name value_T_count value_F_count
=== ==== ============= =============
 1   A         3             2
 2   B         3             0
 3   C         0             2
 4   D         3             0    AA Table (Master)
==================
mid name
=== ====
 1   A
 2   B
 3   C
 4   D    BB Table (Detail)
==================
did mid name value
=== === ==== =====
 1   1   A1    T
 2   1   A2    T
 3   1   A3    F
 4   1   A4    T
 5   1   A5    F
 6   2   B1    T
 7   2   B2    T
 8   2   B3    T
 9   3   C1    F
10   3   C1    F
11   4   D1    T
12   4   D2    T
13   4   D3    T