Hello. I am a bit stuck and confused on how to complete these two parts in SQL c

Question

Hello. I am a bit stuck and confused on how to complete these two parts in SQL command line. Any help would be appreciated.

Part 1 As part of developing a Web application to track volunteer activities, create a table for the volunteer database that tracks user names for the volunteers who log in to the system. Submit the SOL used to create the table. Use a SELECT INTO query with a SQL string function to create user names for the volunteers and insert them into the new table. Submit the SQL to create the new table, the SELECT INTO query, and the result of a SELECT query to show the contents as part of this assessment Part 2 Using SQL aggregate functions such 8s COUNTO, MINO, and MAXO, write three queries to report on various aspects of the organization's volunteers

Explanation / Answer

Solution:

part 1:

CREATE TABLE Volunteer(
    username int(20),

password varchar(40)

  
PRIMARY KEY (username)

);

INSERT INTO Volunteers (username, password) VALUES ('John', 'pass')

INSERT INTO Volunteers (username, password) VALUES ('Doe', 'password')

part 2:

COUTN():

SELECT COUNT(username) FROM Volunteer

MAX():

SELECT MAX(username) FROM Volunteer?

MIN():

SELECT MIN(username) FROM Volunteer?

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.