Let's consider the full version of the staff table. We want to arrange a conference for all experienced IT specialists in the company to discuss the launch of a new product.
Arrange an SQL query to select all employees from the staff table, who work in the IT department with 3 or more years of experience.
id | name | salary | department | experience |
1 | Wendy Spencer | 48000 | sales | 1 |
2 | Mark Klaiton | 52000 | sales | 2 |
3 | Jack Wilson | 60000 | IT | 3 |
4 | Kate Smith | 55000 | IT | 2 |
5 | Tedd Jonson | 68000 | IT | 5 |
6 | Tracy Walberg | 75000 | HR | 10 |
7 | Min Li | 56000 | HR | 3 |
8 | John Preston | 62000 | IT | 4 |