Table 1: DDL create table R (col_a char primary key, co…
Table 1: DDL create table R (col_a char primary key, col_b char ); create table S (col_c char primary key, col_d char, foreign key (col_d) references R(col_a) ); insert into R values (‘a’, ‘d’), (‘b’, ‘e’), (‘c’, ‘f’); insert into S values (‘p’, ‘a’), (‘q’, ‘b’), (‘r’, ‘c’), (‘s’, ‘a’), (‘t’, ‘b’); Based on Table 1: DDL, Show the result of each SQL query below. Use a table or put each row on a separate line with fields separated by tabs so that the columns line up. Clearly separate answers. select R.A, T.C from R, T where R.A = T.B order by R.A, T.C; select distinct R.A, T.C from R, T where R.A = T.B order by R.A, T.C; select R.A, COUNT(T.C) AS C_COUNT from R, T where R.A = T.B group by R.A;