PostgreSQL Exam PGCES-02 Topic 8 Question 30 Discussion

The tables "s1" and "s2" are defined below. The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is of BOOLEAN type, and the column "name" for table "s2" is of TEXT type.

s1: id |

enable

----+--------

1 | t 2 | f

s2: id |

name ----

+------ 1 |

post 2 |

gre 3 |

SQL

The following SQL was executed. Select the correct number of rows in the result. SELECT * FROM s2 WHERE id IN (SELECT id FROM s1);