Answered: I need help creating a table in…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

I need help creating a table in Java/HTML from a SQL database. My syntax isn't working. DB table: create table if not exists bids ( user_id varchar(50), piece_id int, created_at datetime, amount float, primary key (id, piece_id), foreign key (user_id) references accs(user_id), foreign key (pieces_id) references pieces(id)); create table if not exists pieces ( id int auto_increment, seller_id varchar(50), piece_name varchar(255), designer varchar(50), descrip text, closing_time datetime, initial_price float, increment float, minimum float, primary key(id), foreign key(seller_id) references accs(user_id)); I need help creating a table that shows total earning. I know I need to sort the amount float by the maximum value and then get the sum, but it's not working when I try it for some reason. I also need to create a table that shows total earnings by item and account id as well as by piece type. Thanks for help

Expert Solution