This Database made by Arda Kozan. This database connected with GSM company and it contains tables and datas such as tariffs, bills and subscribers who member of branches or main offices and these tables are related with together. If you want to reach these datas you can do that with queries.I've added a few examples in my repository and I described these in below.
You can reach queries this link: https://github.com/Schwartz1/GSM
This query lists informations sort by names of branches that have total number of subscribers more than 2 and have 8-letter and ends with "ğ".List of this query's photo is in the below.
This query lists number of subscribers and branches that have registered on which region.List of this query's photo is in the below.
This query lists informations of subscriber who made a call on current mounth and her tariff that uses which one.List of this query's photo is in the below.
This query insert new branch to database.
This query creates a user who can able to use "select" commands.
This query calculates total debt of subscribers who signed up to ZOOM tariff that have cost 0.5 TL per call minutes and 0.05 per SMS and it lists informations of these subscribers.This list contains tariff that subscriber uses which one.List of this query's photo is in the below.
This query lists informations of subscriber who most signed in to web site on this mounth.This list contains tariff that subscriber uses which one.List of this query's photo is in the below.
