subham13-02

1.Number of matches played per year of all the years in IPL.
		
		SELECT season,COUNT(*) 
			FROM matches 
		GROUP BY season
		ORDER BY season;

2.Number of matches won of all teams over all the years of IPL.
		
		SELECT winner,COUNT(winner) 

subham13-02

mkdir exercise4
cd exercise4
touch README.md intro.txt
echo "Hello WOrld" >intro.txt
git add .
git commit -m "hiillo word"
git --amend -m "Hello world"
git commit --amend -m "Hello world"
git log
echo "Hello WOrld" >>README.md

subham13-02

mkdir exercise2
cd exercise2
git status                  #current branch : master
git -b new-branch
git checkout new-branch       #currrent branch : new-branch
mkdir newFolder
cd newFolder
echo "random message" >message.txt
git add message.txt
git commit -m "commited on newbranch" 

subham13-02

mkdir exercise1           #created exercise1 directory
cd exercise
git init
touch README.md
git status
git add .
git status
git commit -m "first commit"
mkdir src                 #created src directory inside exercise
cd src

subham13-02

curl -o url                                                  #downloaded content from the given url
head -n 3 'Harry Potter and the Goblet of Fire.txt'          #printed first three lines of this file
tail -n 10 'Harry Potter and the Goblet of Fire.txt'         #printed last 10 lines of this file
grep -o -i -w 'Harry\|Ron\|Hermione\|Dumbledore' "Harry Potter and the Goblet of Fire.txt" | wc -l v  #printed number of time those word apear together
sed -n '100,200p' "Harry Potter and the Goblet of Fire.txt"      #Print lines from 100 through 200 i
tr -s '[:space:]' '\n' < "Harry Potter and the Goblet of Fire.txt" |sed 's/[^A-Za-z]/ /g' | tr 'A-Z' 'a-z' | sort | uniq | wc -l   #printed number of unique words  

subham13-02

mkdir hello                                               #created a directory hello
mkdir one                                                 #created a directory one
cd one                                                    #changed the current directory from home to one
touch a.txt b.txt                                         #created  empty txt files a.txt and b.txt
mkdir two                                                 #created a directory two
cd two                                                    #changed the current directory from home to two
tocu d.txt                                                #created a empty txt file d.txt
mkdir three                                               #created a directory three
cd three                                                  #changed the current directory from two to three
tocuh e.txt                                               #created a empty txt file e.txt