اذهب الي المحتوي
أوفيسنا

hafez81

02 الأعضاء
  • Posts

    98
  • تاريخ الانضمام

  • تاريخ اخر زياره

كل منشورات العضو hafez81

  1. 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
  2. لااله الا انت سبحانك انى كنت من الظالمين
×
×
  • اضف...

Important Information