Chegg I hope someone can help me wiht this task, it's difficult and long in my view. I have no idea what I'm doing, so a little help from my experts at chegg would be greatly appreciated.

Based on the Salesdb in Module 2 - "Joins" write an SQL query that will list the first and last names of the buyers who did not sell a chair

Provide the SQL statements needed to update the president database. For example, recent presidents are missing and some have passed away. The presidents DB can be found in Module 2 - SQL Queries. Also search for sites that uses SQL Queries to get information from database and display it on the site. Provide and explain the Queries as well as the URL for the site. Please do not duplicate each other's sites

Below is all the info needed to set this up, the problem

# Create items table for antique auction demo

DROP TABLE IF EXISTS items;

CREATE TABLE items

(

OwnerID char(2) NOT NULL,

ItemDesired char(10) NOT NULL

);

# Create owners table for antique auction demo

DROP TABLE IF EXISTS owners;

CREATE TABLE owners

(

OwnerID char(2) NOT NULL,

OwnerLastName char(10) NOT NULL,

OwnerFirstName char(10) NOT NULL

);

# Create transactions table for antique auction demo

DROP TABLE IF EXISTS transactions;

CREATE TABLE transactions

(

SellerID char(2) NOT NULL,

BuyerID char(2) NOT NULL,

Item char(20) NOT NULL

);

2	Table
2	Desk
21	Chair
15	Mirror

1	Jones	Bill
2	Smith	Bob
15	Lawson	Patricia
21	Akins	Jane
50	Fowler	Sam

1	50	Bed
2	15	Table
15	2	Chair
21	50	Mirror
50	1	Desk
1	21	Cabinet
2	21	Coffee Table
15	50	Chair
1	15	Jewelry Box
2	21	Pottery
21	2	Bookcase
50	1	Plant Stand

# Create president table for US Historical League

DROP TABLE IF EXISTS president;

CREATE TABLE president

(

last_name VARCHAR(15) NOT NULL,

first_name VARCHAR(15) NOT NULL,

suffix VARCHAR(5) NULL, /* name suffix (Jr., II, etc.) */

city VARCHAR(20) NOT NULL,

state VARCHAR(2) NOT NULL,

birth DATE NOT NULL,

death DATE NULL

);

Washington George \N Wakefield VA 1732-2-22 1799-12-14

Adams John \N Braintree MA 1735-10-30 1826-7-4

Jefferson Thomas \N Albemarle County VA 1743-4-13 1826-7-4

Madison James \N Port Conway VA 1751-3-16 1836-6-28

Monroe James \N Westmoreland County VA 1758-4-28 1831-7-4

Adams John Quincy \N Braintree MA 1767-7-11 1848-2-23

Jackson Andrew \N Waxhaw settlement SC 1767-3-15 1845-6-8

Van Buren Martin \N Kinderhook NY 1782-12-5 1862-7-24

Harrison William H. \N Berkeley VA 1773-2-9 1841-4-4

Tyler John \N Greenway VA 1790-3-29 1862-1-18

Polk James K. \N Pineville NC 1795-11-2 1849-6-15

Taylor Zachary \N Orange County VA 1784-11-24 1850-7-9

Fillmore Millard \N Locke NY 1800-1-7 1874-3-8

Pierce Franklin \N Hillsboro NH 1804-11-23 1869-10-8

Buchanan James \N Mercersburg PA 1791-4-23 1868-6-1

Lincoln Abraham \N Hodgenville KY 1809-2-12 1865-4-15

Johnson Andrew \N Raleigh NC 1808-12-29 1875-7-31

Grant Ulysses S. \N Point Pleasant OH 1822-4-27 1885-7-23

Hayes Rutherford B. \N Delaware OH 1822-10-4 1893-1-17

Garfield James A. \N Orange OH 1831-11-19 1881-9-19

Arthur Chester A. \N Fairfield VT 1829-10-5 1886-11-18

Cleveland Grover \N Caldwell NJ 1837-3-18 6/24/1908

Harrison Benjamin \N North Bend OH 1833-8-20 3/13/1901

McKinley William \N Niles OH 1843-1-29 9/14/1901

Roosevelt Theodore \N New York NY 1858-10-27 1/6/1919

Taft William H. \N Cincinnati OH 1857-9-15 3/8/1930

Wilson Woodrow \N Staunton VA 1856-12-19 2/3/1924

Harding Warren G. \N Blooming Grove OH 1865-11-2 8/2/1923

Coolidge Calvin \N Plymouth Notch VT 1872-7-4 1/5/1933

Hoover Herbert C. \N West Branch IA 1874-8-10 10/20/1964

Roosevelt Franklin D. \N Hyde Park NY 1882-1-30 4/12/1945

Truman Harry S. \N Lamar MO 1884-5-8 12/26/1972

Eisenhower Dwight D. \N Denison TX 1890-10-14 3/28/1969

Kennedy John F \N Brookline MA 5/29/1917 11/22/1963

Johnson Lyndon B. \N Stonewall TX 8/27/1908 1/22/1973

Nixon Richard M \N Yorba Linda CA 1/9/1913 4/22/1994

Ford Gerald R \N Omaha NE 7/14/1913 \N

Carter James E. Jr. Plains GA 10/1/1924 \N

last_name	first_name	suffix	city	state	birth	death
Washington	George		Wakefield	VA	1732-2-22	1799-12-14
Adams	John		Braintree	MA	1735-10-30	1826-7-4
Jefferson	Thomas		Albemarle County	VA	1743-4-13	1826-7-4
Madison	James		Port Conway	VA	1751-3-16	1836-6-28
Monroe	James		Westmoreland County	VA	1758-4-28	1831-7-4
Adams	John Quincy		Braintree	MA	1767-7-11	1848-2-23
Jackson	Andrew		Waxhaw settlement	SC	1767-3-15	1845-6-8
Van Buren	Martin		Kinderhook	NY	1782-12-5	1862-7-24
Harrison	William H.		Berkeley	VA	1773-2-9	1841-4-4
Tyler	John		Greenway	VA	1790-3-29	1862-1-18
Polk	James K.		Pineville	NC	1795-11-2	1849-6-15
Taylor	Zachary		Orange County	VA	1784-11-24	1850-7-9
Fillmore	Millard		Locke	NY	1800-1-7	1874-3-8
Pierce	Franklin		Hillsboro	NH	1804-11-23	1869-10-8
Buchanan	James		Mercersburg	PA	1791-4-23	1868-6-1
Lincoln	Abraham		Hodgenville	KY	1809-2-12	1865-4-15
Johnson	Andrew		Raleigh	NC	1808-12-29	1875-7-31
Grant	Ulysses S.		Point Pleasant	OH	1822-4-27	1885-7-23
Hayes	Rutherford B.		Delaware	OH	1822-10-4	1893-1-17
Garfield	James A.		Orange	OH	1831-11-19	1881-9-19
Arthur	Chester A.		Fairfield	VT	1829-10-5	1886-11-18
Cleveland	Grover		Caldwell	NJ	1837-3-18	1908-6-24
Harrison	Benjamin		North Bend	OH	1833-8-20	1901-3-13
McKinley	William		Niles	OH	1843-1-29	1901-9-14
Roosevelt	Theodore		New York	NY	1858-10-27	1919-1-6
Taft	William H.		Cincinnati	OH	1857-9-15	1930-3-8
Wilson	Woodrow		Staunton	VA	1856-12-19	1924-2-3
Harding	Warren G.		Blooming Grove	OH	1865-11-2	1923-8-2
Coolidge	Calvin		Plymouth Notch	VT	1872-7-4	1933-1-5
Hoover	Herbert C.		West Branch	IA	1874-8-10	1964-10-20
Roosevelt	Franklin D.		Hyde Park	NY	1882-1-30	1945-4-12
Truman	Harry S.		Lamar	MO	1884-5-8	1972-12-26
Eisenhower	Dwight D.		Denison	TX	1890-10-14	1969-3-28
Kennedy	John F		Brookline	MA	1917-5-29	1963-11-22
Johnson	Lyndon B.		Stonewall	TX	1908-8-27	1973-1-22
Nixon	Richard M		Yorba Linda	CA	1913-1-9	1994-4-22
Ford	Gerald R		Omaha	NE	1913-7-14
Carter	James E.	Jr.	Plains	GA	1924-10-1
Reagan	Ronald W.		Tampico	IL	1911-2-6
Bush	George W.		Milton	MA	1924-6-24
Clinton	William J.		Hope	AR	1946-8-19