Basic CRUD - Exercise

Problems

01. Select Cities

Problem Description

Database

02. Concatenate

03. Remove Duplicate Rows

04. Limit Records

05. Skip Rows

06. Find the Addresses

07. Positive Even Number

08. Projects within a Date Range

09. Multiple Conditions

10. Set of Values

11. Compare Character Values

12. Salary

13. Missing Value

14. INSERT Departments

15. New Table

16. Update the Project End Date

17. Award Employees with Experience

18. Delete Addresses

19. Create a View

20. Create a View with Multiple Tables

21. ALTER VIEW

22. DROP VIEW

23. UPPER

24. SUBSTRING

25. LIKE