Sqlite代寫、SQL執行語句代寫

標籤：example   語句   form   htm   迭代   accept   using   工具包   only   

Sqlite代寫、SQL執行語句代寫
SQL Assignment 2 (20%)
Questions:
1. Produce a table showing the total books that are currently “CheckedOut” by every major. Show the
Major and “Total Books Checkedout” in the query result and sort the “Total Books Checkedout” in
descending order. Use only the MediaCode in the Where condition.
2. Produce a table showing the total books published by each author between 2000 and 2015. Show only
the rows if the total published books is greater or equal 3. Sort the authors in ascending order.
Assuming you do not know the MediaID but you know the MediaCode.
Author Total Books Published
3. Find the customers who have an item due on the 8th August 2015 and has not “checkedin” in the loan
table. Sort the Full Name in ascending order. Show only the date without the time. Do not use
strftime() in this question.
Full Name Title DueDate
4. The library would like to know the number of times a customer has an overdue fee and their total
overdue fee. Sort the output by the ‘Number of times overdue’ in descending order then by the ‘Total
overdue fee’ in descending order. Show only the total overdue fee greater or equal to $5 but less than
$100.
Full Name Number of Times
Overdue
Total Overdue Fee
5. (a) Find all the unique customer full name with at least one loan.
*Important*
(1) Use the join syntax below for questions that require an inner join. Other syntax will not
be accepted.
SELECT column-list
FROM table 1 JOIN table 2 ON joint-condition
Where conditions
(2) Use “=” sign, for example “percent_time =100” not “percent_time IS 100”.
(b) Use 5(a) as a subquery, find all INFO students who did not make any loan. Include both their Full
Name, CustomerID, and Major in your results.
CustomerID Full Name Major
{The format of full name should be “Last Name, First
Name”.}
INFO
6. (a) Find the total overdue fee for the customer "Barclay, Fletcher" without using ID in the query.
(b) How many distinct students (exclude "Barclay, Fletcher") with a single overdue fee greater than
half the total overdue fee of "Barclay, Fletcher"? You must use 6(a) as a subquery. You must use
the “NOT” SQL in this question.
7. The manager is interested to know yearly borrowing volume by Gender. Present a table displaying the
Gender, Year, Month and The Number of Loans. Sort the results in descending order by Gender,
ascending order by Year and ascending order by Month. Show only the rows if the number of loans is
less than 25.
Hint: (1) Use CheckedOut date to extract the year and month when the book is loaned; (2) Use
strftime() function to deal with the year and month.
Gender Year Month The Number of Loans
M
…
F
8. (a) Find the total number of loan for each customerID.
(b) Show the total number of loan for each customer include customers who have no loan. You must
use 8(a) as sub-query to form the right part of the outer join table. Show the result according to the
format below.
CustomerID LastName FirstName Totalloan
9. Show the number of books published each year by each author. Show only the rows for author who
published more than 1 book in a year. The table should show author, Pubyear, and “Total Book
Published in Year”. MediaID should not be used in this query, use MediaCode.
10. Use only a left outer join to find the customers who did not make any loan. Show the CustomerID, Full
Name, and Major. Show only the rows contain “INFO” major only.
CustomerID Full Name Major
{The format of full name should be “Last Name, First
Name”.}
INFO
11. How many students with a total overdue fee greater than half the total overdue fee of "Barclay,
Fletcher" (exclude "Barclay, Fletcher")?
12. Use the SQL date modifier expression in chapter 44 of the Sqlite tutorial to add 3 days, 8 hours, 3
minutes, and 45 seconds to the date “2018-05-11 23:59:59”. This question does not require a
database.
http://www.daixie0.com/contents/15/1278.htm

 

本團隊核心人員組成主要包括矽谷工程師、BAT一線工程師，國內Top5碩士、博士生，精通德英語！我們主要業務範圍是代做編程大作業、課程設計等等。

 

我們的方向領域：window編程 數值演算法 AI人工智慧 金融統計 計量分析 大資料 網路編程 WEB編程 通訊編程 遊戲編程多媒體linux 外掛編程 程式API影像處理 嵌入式/單片機 資料庫編程 控制台 進程與線程 網路安全  組合語言 硬體編程 軟體設計 工程標準規等。其中代寫代做程式設計語言或工具包括但不限於以下範圍:

C/C++/C#代寫

Java代寫

IT代寫

Python代寫

輔導編程作業

Matlab代寫

Haskell代寫

Processing代寫

Linux環境搭建

Rust代寫

Data Structure Assginment 資料結構代寫

MIPS代寫

Machine Learning 作業 代寫

Oracle/SQL/PostgreSQL/Pig 資料庫代寫/代做/輔導

Web開發、網站開發、網站作業

ASP.NET網站開發

Finance Insurace Statistics統計、迴歸、迭代

Prolog代寫

Computer Computational method代做

 

因為專業，所以值得信賴。如有需要，請加QQ：99515681 或郵箱：[email protected]

：codinghelp

Sqlite代寫、SQL執行語句代寫