In: Computer Science
Select the ProjectID, ProjectStartDate, ClientName, TaskID, and Description fields for TaskID TEST01 and a ProjectStartDate after 1/1/2020. Sort the records in ascending order by ProjectStartDate. What are the ProjectStartDate and ClientName values in the first record of the results?
a. 1/6/2020, Midstates Auto Auction
b. 2/7/2019 Jobot Developers
c. 4/10/2020, Bretz & Hanna Law Firm
d. 1/14/2022, SkyFactor
The correct answer is (c).
Explain:
|
Review3 |
||||
|
ProjectID |
ProjectStartDate |
ClientName |
TaskID |
Description |
|
4 |
4/10/2020 |
Bretz & Hanna Law Firm |
TEST01 |
Test technology |
|
13 |
11/30/2020 |
Jobot Developers |
TEST01 |
Test technology |
|
14 |
12/9/2020 |
Jillian Henry & Associates |
TEST01 |
Test technology |
|
15 |
12/21/2020 |
The HELPCard |
TEST01 |
Test technology |
|
17 |
2/15/2021 |
MarketPoint Sales |
TEST01 |
Test technology |
|
22 |
9/30/2021 |
Juxly Engineering |
TEST01 |
Test technology |
|
24 |
1/14/2022 |
SkyFactor |
TEST01 |
Test technology |