2. Base on the table you designed, please write down the query statement for the following requests:

Question

Sigiloso · Accepted Answer

a. Get all distinct lanes belong "Hoping Rd, Taipei City"

```sql
SELECT lane
FROM Address
WHERE road = 'Hoping Rd'
	AND city = 'Taipei City'
```

b. Get all odd numbers under "Ln.10, Hoping Rd, Taipei City"

```sql
SELECT number
FROM Address
WHERE lane = 'Ln.10'
  AND road = 'Hoping Rd'
  AND city = 'Taipei City'
  AND MOD(CAST(number AS INT), 2) = 1;
```

Tomofun