2 project
 
	 
 
	Prepare two tables: tbl1 and tbl2. Each table has about 100 rows. The tables are relational, with a foreign key. We will demonstrate the three basic operations of data analytics:
 
	·        Aggregation,
 
	·        Filter, and
 
	·        Join
 
	You need to implement the following queries.
 
	Consider the example on the Excel file (exmpls.xlsx)
 
	·        Aggregation: SELECT count(*) FROM tbl1 GROUP BY City
 
	·        Filter: SELECT Name FROM tbl1 WHERE Age > 40
 
	·        Join: SELECT Name FROM tbl1, tbl2 WHERE Salary > 5000
 
	You can pick any system/language to implement the project:  Excel
 
	انتبه من فضلك ... مشاركة مكررة , تــــم بالفعل حذف المشاركة الأخرى
 
	hafez excel22.xlsx