Lv 191 points

Haley

Favourite answers0%
Answers0
Questions2
  • Attachment image

    Need help with SQL database!!!?

    Write a SQL statement to display the course number, number of sections, and total capacity for courses having less than three sections.

    Write a SQL statement to list the IDs of instructors who teach exactly nine sections.

    Write a SQL statement to give the number of courses that require prerequisites.

    Write a SQL statement to determines the total number of students enrolled with each student is counted only once.

    Write a SQL statement to list the IDs of students who have enrolled three classes.

    3 AnswersProgramming & Design4 months ago
  • Attachment image

    Need help with SQL database questions!!!?

    Write a SQL statement that gives the average of the grades in table GRADE.

    Write a SQL statement that counts the number of cities in table ZIPCODE; each city is counted only once.

    Write a SQL statement to show course description in alphabetical order.

    Write a SQL statement to list zipcodes and cities in state CT sorted by zipcode.

    Write a SQL statement to list first and last names of all instructors sorted by last name.

    Write a SQL statement to show course descriptions that have the course number 20 as a prerequisite.

    Write a SQL statement to list the IDs of students that are hired by New York Pop.

    Write a SQL statement to list first and last names of students that live in zip code 11434 or 11435.

    Write a SQL statement that removes all the zeros from this number: 000123450000.

    Write a SQL statement to list the first four characters of the first name of each instructor.

    Write a SQL statement to list student first and last names, where each first name must begin with a letter 'A', and also orders the result set based on the length

     of students' last name.

    Write a SQL statement that shows the result of this arithmetic operation: 8/5 + 6.

    Write a SQL statement to list the last names of instructors, where a last name contains exactly six characters.

    Write a SQL statement to count the number of instructors with a letter 'n' in their last name.

  • Attachment image

    Programming Assignment Help?

    We have been using simple java coding. Read images from left to right.

  • Attachment image

    Programming Homework Help Credit card validation?

    View the images from left to right. Any help is appriciated thank you.

    Homework Help9 months ago