All Tasks
Calculate Company Age
Show company names and calculate how many years old each company is (use 2025 as current year).
Reference Tables
Companies
(companies)
| id | company_name | industry | country | founded_year |
|---|---|---|---|---|
| 1 | TechCorp | Technology | USA | 2010 |
| 2 | Global Motors | Automotive | Germany | 1985 |
| 3 | Green Energy Solutions | Energy | Denmark | 2015 |
| 4 | Fashion Forward | Retail | Italy | 2008 |
| 5 | Data Analytics Inc | Technology | Canada | 2018 |
| 6 | Ocean Shipping | Logistics | Netherlands | 1995 |
| 7 | Mountain Coffee | Food & Beverage | Colombia | 2012 |
| 8 | Solar Dynamics | Energy | Spain | 2020 |
| 9 | Urban Construction | Construction | Japan | 2005 |
| 10 | Smart Home Systems | Technology | South Korea | 2019 |
Orders
(orders)
| id | order_number | order_date | amount | status | company_id |
|---|---|---|---|---|---|
| 1 | ORD-001 | Jan. 15, 2024 | 25000.00 | Completed | 1 |
| 2 | ORD-002 | Feb. 20, 2024 | 15000.00 | Completed | 1 |
| 3 | ORD-003 | Jan. 30, 2024 | 75000.00 | Completed | 2 |
| 4 | ORD-004 | March 10, 2024 | 50000.00 | Pending | 3 |
| 5 | ORD-005 | Feb. 28, 2024 | 12000.00 | Completed | 4 |
| 6 | ORD-006 | March 15, 2024 | 8000.00 | Pending | 4 |
| 7 | ORD-007 | Jan. 22, 2024 | 95000.00 | Completed | 6 |
| 8 | ORD-008 | March 5, 2024 | 3500.00 | Completed | 7 |
| 9 | ORD-009 | Feb. 14, 2024 | 22000.00 | Completed | NULL |
| 10 | ORD-010 | March 20, 2024 | 18000.00 | Pending | NULL |