Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please download zmirimcard.sqlite database to your computers, and write SQL queries using SQLiteStudio to answer following questions: Please submit both SQL queries and displayed results.
Please download zmirimcard.sqlite database to your computers, and write SQL queries using SQLiteStudio to answer following questions: Please submit both SQL queries and displayed results. You can provide screenshots of in a word file. 1. Find the number of full fares 2. Find the number of zdeniz travelers 3. Find the number of Eshot travelers under educationist category 4. Find the number of students traveling with Metro in September. 5. Please propose a question to support a managerial decision and write an SQL query to find the answer. Use both the scans table and cards table to get the answer. Make sure you have watched Week13 input session video before submitting this assignment. I will grade your assignment submission using the following rubric. Please check it to make sure that your submission includes the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started