Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 10, 2024

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 with AI-Powered 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

Students also viewed these Databases questions

Question

DSM-5 allows clinicians to classify individuals with ID based on their adaptive functioning: mild, moderate, severe, or profound.

Answered: 1 week ago

Question

★★★★★

Following is a portion of the computer output for a regression analysis relating y = maintenance expense (dollars per month) to x = usage (hours per week) of a particular brand of computer terminal....

Answered: 1 week ago

Question

★★★★★

For part (b) please draw the diagram with arrows Consider a party that we denote as A. The current assets and liabilities of A are as follows. A receives 2% fixed interest on a 5 yr loan of size...

Answered: 1 week ago

Question

★★★★★

According to a report issued by the CDC in 2013, 66.8 % of women 40 years of age and over had a mammogram within the last two years. An oncologist at the CDC would like to know if there has been a...

Answered: 1 week ago

Question

★★★★★

iid Estimating variance for normal data. Suppose that we observe data X1, ..., Xn N(0, v) we know the mean is 0, but we don't know the variance v. (We are writing variance = v, instead of , to make...

Answered: 1 week ago

Question

★★★★★

Four small spheres, each of which you can regard as a point of mass 0.200 kg, are arranged in a square 0.400 m on a side and connected by light rods a)Find the moment of inertia of the system about...

Answered: 1 week ago

Question

★★★★★

In the class, we leamt the capital recovery factor (CRF) that is given as i(1+i)n (1+i)n - 1 where i the interest rate and n is the number of annuities received. CRF 4a) (10pts) Given i, find the...

Answered: 1 week ago

Question

★★★★★

Despite growing regulation and recognition of quality management system (with Nigeria as a case study), the influx of fake and substandard products is becoming difficult to control. Required: As a...

Answered: 1 week ago

Question

★★★★★

Activity 3 Response: As an investigation of scientific question B, consider an object that is not the human body, but that also has a consistently higher temperature than the environment. Based on...

Answered: 1 week ago

Previous Question Next Question