/MiniSql

Primary LanguagePython

MiniSql

This directory contans a sql engine which runs a subset of SQL queries using command line interface.

metadata

  • schema of db is present in file 'metadata.txt'
  • individual tables are present in file 'table1.csv'

sample queries

  • select all records from one or more tables
  • aggregate functions like min,max,sum,avg
  • project columns
  • project distinct columns
  • project data using where clause
  • join of tables

For more information refer to the PDF.