Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

Students also viewed these Databases questions

Question

Challenges Facing Todays Organizations?

Answered: 1 week ago