text: CREATE TABLE checking (balance INTEGER, custid VARCHAR); CREATE TABLE savings (balance INTEGER, custid VARCHAR); CREATE TABLE accounts (name VARCHAR, custid VARCHAR) -- Find the name and total checking and savings balance of the accounts whose savings balance is lower than corresponding checking balance. SELECT T1.name, T3.balance + T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid JOIN savings AS T3 ON T1.custid = T3.custid WHERE T3.balance < T2.balance CREATE TABLE savings (balance VARCHAR, custid VARCHAR); CREATE TABLE accounts (name VARCHAR, custid VARCHAR) -- Find the name and savings balance of the top 3 accounts with the highest saving balance sorted by savings balance in descending order. SELECT T1.name, T2.balance FROM accounts AS T1 JOIN savings AS T2 ON T1.custid = T2.custid ORDER BY T2.balance DESC LIMIT 3 CREATE TABLE browser (market_share VARCHAR) -- How many main stream browsers whose market share is at least 5 exist? SELECT COUNT(*) FROM browser WHERE market_share >= 5 CREATE TABLE browser (name VARCHAR, market_share VARCHAR) -- List the name of browsers in descending order by market share. SELECT name FROM browser ORDER BY market_share DESC CREATE TABLE browser (id VARCHAR, name VARCHAR, market_share VARCHAR) -- List the ids, names and market shares of all browsers. SELECT id, name, market_share FROM browser CREATE TABLE browser (market_share INTEGER) -- What is the maximum, minimum and average market share of the listed browsers? SELECT MAX(market_share), MIN(market_share), AVG(market_share) FROM browser