Example of database query
This is a database table.
| Rec # | Field1 | Field2 | Field3 |
|---|---|---|---|
| 1 | Paul | Johnson | 450 |
| 2 | George | Brown | 335 |
| 3 | Paul | Gray | 845 |
| 4 | Tom | Young | 335 |
| 5 | Tom | Sanders | 400 |
Given the table above, what would be the resulting table for this query?
| Field1 |
|---|
| Paul |
Given the table above, what would be the resulting table for this query?
| Field1 | Field3 |
|---|---|
| George | |
| >400 |
Given the table above, what would be the resulting table for this query?
| Field1 | Field3 |
|---|---|
| Tom | <375 |