add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
8.0.36
Records: 4  Duplicates: 0  Warnings: 0
a_id total_count pass_count fail_count
1 3 2 1
2 null null null
3 2 null null
4 null null null
Records: 12  Duplicates: 0  Warnings: 0
b_id a_id isPassed
1 1 Y
2 1 N
3 1 Y
4 2 N
5 2 N
6 2 Y
7 2 N
8 3 Y
9 3 Y
10 4 N
11 4 N
12 4 Y
Rows matched: 4  Changed: 3  Warnings: 0
a_id total_count pass_count fail_count
1 3 2 1
2 4 1 3
3 2 2 0
4 3 1 2