View the step-by-step solution to:

/* These problems are similar to the examples you've seen in the textbook. You must use SQL Developer and connect to the database server here on...

I need help with a lab using my SQL Oracle SQL Developer. Can someone help me please?

I can give you more info if you are interested in helping me.

/* These problems are similar to the examples you've seen in the textbook. You must use SQL Developer and connect to the database server here on campus. Comment symbols: /* and */ /* Comment symbols are used to comment out multiple lines of text. That means the lines will be ignored when you use the SCRIPT mode to run all the commands at once. Double-dashes comment out a single line. For example, all this text at the beginning of the assignment is commented out. In this assignment put your SQL command below its problem statement outside the comment symbols so the command will run. Use the SCRIPT mode in SQL Developer when you execute your commands below. Save the output with a file extension of TXT. Please do NOT use anything but Notepad or an equivalent (WordPad is NOT okay). Submit the SOLUTION file (the one with SQL problem statements and commands) and the OUTPUT file. Leave the PROMPT commands alone! They will provide an easy-to-read output. */ -- Leave these commands here. They show who you are and when you -- ran the solution file. show user; select sysdate from dual; PROMPT PROMPT Working with single tables PROMPT PROMPT ************************ PROMPT 2.1.1 /* Schema: Borderpat Show Transfers. Show all the columns. Sort by (order by) the facility code from which the equipment is being sent but sort in descending order (Z to A). HINT: Use DESC to see the columns. Which of these is the one that shows the facility code the transfer was sent from? */ PROMPT ************************ PROMPT 2.1.2 a and b /* Schema: Borderpat 2.1.2.a. Count the records in the personnel table. Show only the number.
Background image of page 1
2.1.2.b. Show personnel. Show personnel code, first name, last name and facility code but show only the personnel at the BTC facility (the BTC faccode). */ PROMPT ************************ PROMPT 2.1.3 a and b /* MOVIEDB 2.1.3.a. Count how artists there are. Show only the number. 2.1.3.b. Show the British artists. Show only the artist ID, the first name, the last name and the nationality. */ PROMPT ********************** PROMPT 2.1.4 a and b /* Schema: MOVIEDB 2.1.4.a Count how many movies were released in 1988. Show only the number. 2.1.4.b Show movies that are comedies and were released in 1988. Show the movie ID, title, category, and year released. */ PROMPT ********************** PROMPT 2.1.5 /* Schema: BORDERPAT Show all the columns in the personnel table for personnel who are the Chief Patrol Agent. Sort the output by last name. */
Background image of page 2
/* When you open this file, save it under another name. Create all your SQL code first. Enter it below the problem statement. Test you commands and correct errors before creating the output file to submit. Use SQL Developer in script mode to run your solution script. Save the output to a TXT or SQL file. Submit your solution file and the output file online. */ show user; select sysdate from dual; PROMPT **********************************; PROMPT 4.3.1; PROMPT; /* PeerEval List teams and the members of each team. List the team ID, team name, and the full name of each student. Sort by team ID and the student last name. Use the JOIN operator. */ PROMPT **********************************; PROMPT 4.3.2; PROMPT; /* PeerEval List each student on the Technoloy Solutions team that has done evaluations and list their evaluations. Show the team name (not just the ID), the student ID, student name, the evaluation ID, and evaluatee ID. Use the JOIN operator. Sort by student ID. */ PROMPT **********************************; PROMPT 4.3.3; /* PeerEval List students who are not assigned to a team. List the student's ID, full name, and team ID (which is null). Sort in descending order by last name. */
Background image of page 1
PROMPT **********************************; PROMPT 4.3.4; /* borderpat List all the facilities in the western region (WRO) and the people assigned there. Show the facility code and name, person's first and last name, and the person's position. Sort by facility code and position. Using column aliases with regular words for the column headings. */
Background image of page 2

Top Answer

View the full answer
SQL_basics_1_sp2017.txt

/* These problems are similar to the examples you've seen in the textbook. You must use SQL Developer and connect to the database server here on campus. Comment symbols: /* and */ /* Comment...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online