Question Details

(Solved) I am taking a SQL course. I am working in MySQL Workbench. How do I save all of the queries onto one sql document or save the database itself to send...


I am taking a SQL course. I am working in MySQL Workbench. How do I save all of the queries onto one sql document or save the database itself to send my work. My assignment has 10 different queries, the last one I did, I had to save 10 different times and that was not what she wanted. 

  • 1.       Show me all the films that have the word drama in their description. Only display the following columns: film id, title, description, release year, special features. Sort them ascending by release year, and descending by film id.
  • 2.       Show me the different ratings within the film table. Your SQL should eliminate any duplicate entries and only show me the distinct ratings.
  • 3.       Show me all columns from the payment table where the payment date is greater than or equal to February 1, 2006. Sort the results by customer id ascending. (Hint: You will have to use the date in the format of 2006-02-01 in your where clause)
  • 4.       Show me all the actors from the actor table. Show only one column that you name full_name; this is a concatenation of the first name and last name with a space in between.
  • 5.       I want to know how much more I could have made if I increased the amount charged on the payment table by 25%. Show me rental id, amount, and 25% of the amount for each record on the payment table. Your new column should be titled new_amount.
  • 6.       Show me all the films that have a rental duration in 3 or 4.
  • 7.       Show me all columns from the customers whose first name begin with Lil sorted by first name in descending order. (Hint: You should only have 2 rows in your result set)
  • 8.       Show me only the first name and last name of all the customers whose last name begin with K and are only 3 letters long.
  • 9.       Show me all the customers whose first name does not start with an A, sorted by first nameascending.
  • 10.   Show me all the staff who has a null password.

Grading:

·        In addition to meeting all the specified criteria under the Directions section, you must use the Beautify feature in MySQL so your SQL is easily readable.

·        Points will be deducted if each question is not clearly labeled within your SQL file. You will do this by commenting out the descriptive line with the pound sign as shown in the MySQL Expressions tutorial video. See example below.Your final file will have a comment, then sql statement, then comment, then sql statement, etc.

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200150117.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now