PSQL Command Line: Thanks! -B open PSQL. Type in the following command to change

Question

PSQL Command Line:

Thanks!

-B

open PSQL. Type in the following command to change your prompt: set PROMPT 1 %n %R%# This will set your prompt to display your db name and the user you are logged in as Next, create a role with your first name. Set it to be able to create databases. Use this role to create a database called hwXXX where XX is your first nam e. Create the following table in hwXXX. You have just started a new company. It is time to hire some employees. You will need to create a table that will contain the following information about your new employees: firstname, lastname, title, id, age, city, state, and salary. Your table will be named empinfoMG, where MG is your first andlast initial. Insert statement exercises After you have created the table, insert thefollowing employees into the table: Sample Table: empinfoxx

Explanation / Answer

(note * means all columns)

2)SELECT * FROM empinfoMG WHERE salary >30000;

3)SELECT first,last FROM empinfoMG WHERE age<30;

4)SELECT first,last,salary FROM empinfoMG WHERE title='programmer';

5)SELECT * FROM empinfoMG WHERE last='ebe';

6)SELECT first FROM empinfoMG WHERE first='potsy';

7)SELECT FROM empinfoMG WHERE age>30;

8)SELECT * FROM empinfoMG

9)SELECT first,age FROM empinfoMG

11)SELECT FROM empinfoMG WHERE age>40;

12)

SELECT first,last FROM empinfoMG

13)

SELECT * FROM empinfoMG

14)

SELECT * FROM empinfoMG

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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