Your question is Basic SQL Query. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Write a SQL query to query a database for Zynga.
Assume the relevant table is companies. Return the record whose company name is Zynga.
company_id, company_name, industry, headquarters_city, and founded_yearcompany_id in ascending order| Column | Type | Description |
|---|---|---|
| company_idPK | INT | Unique company identifier |
| company_name | VARCHAR(100) | Company name |
| industry | VARCHAR(100) | Primary industry classification |
| headquarters_city | VARCHAR(100) | City where the company is headquartered |
| founded_year | INT | Year the company was founded |