Execute SQL queries to get the countries in which the population has fallen from one year to the next, and the years in which it has occurred. Dump the output in the following format:
| country | year | population | year | population |
| 1 | 2005 | 82500849 | 2006 | 82437995 |
| 1 | 2006 | 82437995 | 2007 | 82314906 |
(...)
And so on.
These are the SQL files:
Tables: pastebin.com/xw0j1NAM
Data: pastebin.com/hnpFT3QR
In: Computer Science
Jeffery has just concluded a ratio analysis comparing its performance and position at 31 December 2006 with those at 31 December 2005. The directors are concerned to see that the current ratio and quick ratio show a considerable decline. You are required: (a) State and explain three possible causes for the decline in one or both of these ratios. (b) State and explain three ways in which the company could improve these ratios.
In: Accounting
-Select a publicly traded company, and describe its current distribution policy. (Caterpillar Inc is the company) B-Describe the procedures the company followed when it made the last distribution through dividend payments or through a stock repurchase. C- Analyze how the last distribution impacted the company's intrinsic stock price per share. D- Evaluate the company's current distribution policy, i.e. discuss the advantages and disadvantages of the company's current distribution policy.
In: Accounting
Write a program that displays all the cars in the given file (no sorting). Each car property is separated by a tab character: \t
Given file:
cars.txt
make model year Ford Expedition 2003 Mazda B-Series 1989 Ford Freestar 2003 Hyundai Elantra 2001 Hyundai Entourage 2008 Chevrolet Camaro 2011 Chevrolet Monte Carlo 2006 Chevrolet Blazer 1996 Chevrolet Aveo 2005 Chevrolet Corvette 1999 Mercedes-Benz E-Class 2006 Dodge Avenger 1995 Pontiac Grand Prix 1973 Mitsubishi Outlander 2011 MINI Clubman 2011 Suzuki Aerio 2007 Dodge Dakota Club 1992 Chevrolet Astro 2002 Chevrolet Tahoe 1996 Mitsubishi Mirage 1994 Porsche 944 1991 Hyundai Elantra 1994 Mercury Grand Marquis 1998 Volkswagen Golf 2001 Jaguar XJ Series 2005 Toyota Echo 2005 GMC Safari 2002 GMC Sierra 1500 2000 Chevrolet Cobalt 2005 Jeep Patriot 2008 Mazda Navajo 1991 Chevrolet Malibu 2001 Saab 900 1990 Mercury Grand Marquis 1998 Hummer H1 2004 Subaru Loyale 1993 Jeep Wrangler 1999 Ford Mustang 1994 Austin Mini Cooper S 1963 Mercedes-Benz M-Class 1998 Jeep Wrangler 2006 Honda Civic 1997 Plymouth Voyager 1994 Ford Club Wagon 1997 Audi 5000S 1984 Saturn VUE 2003 Oldsmobile Achieva 1994 Mercedes-Benz G55 AMG 2006 Chevrolet Express 3500 1997 Lexus ES 1992 Cadillac Allante 1992 Hyundai Tiburon 1997 Pontiac Grand Prix 1965 Ford Focus 2000 Mitsubishi Chariot 1987 Chrysler Prowler 2001 Land Rover Discovery 2012 Volkswagen Scirocco 1984 Ford Bronco 1984 Hyundai Accent 1996 Volkswagen Routan 2012 Volkswagen Golf 2003 GMC Terrain 2010 Ford F150 2009 GMC Sierra 2011 Dodge Ram Van 1500 2000 Chrysler 300 2009 Oldsmobile Achieva 1997 Land Rover Discovery 2008 Toyota 4Runner 2002 Porsche 911 1995 Toyota Land Cruiser 2002 Land Rover Defender 1994 Chevrolet Lumina 1997 Audi TT 2002 Chrysler Town & Country 2009 Nissan Frontier 2000 Toyota Tercel 1997 Buick Riviera 1997
Output needed:
Required Output
Ford Expedition 2003\n
Mazda B-Series 1989\n
Ford Freestar 2003\n
Hyundai Elantra 2001\n
Hyundai Entourage 2008\n
Chevrolet Camaro 2011\n
Chevrolet Monte Carlo 2006\n
Chevrolet Blazer 1996\n
Chevrolet Aveo 2005\n
Chevrolet Corvette 1999\n
Mercedes-Benz E-Class 2006\n
Dodge Avenger 1995\n
Pontiac Grand Prix 1973\n
Mitsubishi Outlander 2011\n
MINI Clubman 2011\n
Suzuki Aerio 2007\n
Dodge Dakota Club 1992\n
Chevrolet Astro 2002\n
Chevrolet Tahoe 1996\n
Mitsubishi Mirage 1994\n
Porsche 944 1991\n
Hyundai Elantra 1994\n
Mercury Grand Marquis 1998\n
Volkswagen Golf 2001\n
Jaguar XJ Series 2005\n
Toyota Echo 2005\n
GMC Safari 2002\n
GMC Sierra 1500 2000\n
Chevrolet Cobalt 2005\n
Jeep Patriot 2008\n
Mazda Navajo 1991\n
Chevrolet Malibu 2001\n
Saab 900 1990\n
Mercury Grand Marquis 1998\n
Hummer H1 2004\n
Subaru Loyale 1993\n
Jeep Wrangler 1999\n
Ford Mustang 1994\n
Austin Mini Cooper S 1963\n
Mercedes-Benz M-Class 1998\n
Jeep Wrangler 2006\n
Honda Civic 1997\n
Plymouth Voyager 1994\n
Ford Club Wagon 1997\n
Audi 5000S 1984\n
Saturn VUE 2003\n
Oldsmobile Achieva 1994\n
Mercedes-Benz G55 AMG 2006\n
Chevrolet Express 3500 1997\n
Lexus ES 1992\n
Cadillac Allante 1992\n
Hyundai Tiburon 1997\n
Pontiac Grand Prix 1965\n
Ford Focus 2000\n
Mitsubishi Chariot 1987\n
Chrysler Prowler 2001\n
Land Rover Discovery 2012\n
Volkswagen Scirocco 1984\n
Ford Bronco 1984\n
Hyundai Accent 1996\n
Volkswagen Routan 2012\n
Volkswagen Golf 2003\n
GMC Terrain 2010\n
Ford F150 2009\n
GMC Sierra 2011\n
Dodge Ram Van 1500 2000\n
Chrysler 300 2009\n
Oldsmobile Achieva 1997\n
Land Rover Discovery 2008\n
Toyota 4Runner 2002\n
Porsche 911 1995\n
Toyota Land Cruiser 2002\n
Land Rover Defender 1994\n
Chevrolet Lumina 1997\n
Audi TT 2002\n
Chrysler Town & Country 2009\n
Nissan Frontier 2000\n
Toyota Tercel 1997\n
Buick Riviera 1997\n
My program so far:
import java.io.*;
import java.util.Scanner;
public class PS1{
public static void main(String[] args) {
try{
Scanner scnr = new Scanner(new File("cars.txt"));
String headings = scnr.nextLine();
String line;
String make;
StringBuilder model;
String temp;
int year=0;
while(scnr.hasNext()){
line = scnr.nextLine();
Scanner scnr2 = new Scanner(line);
make = scnr2.next();
model = new StringBuilder(scnr2.next());
while(scnr2.hasNext()){
temp = scnr2.next();
if(scnr2.hasNext())
model.append(" ").append(temp);
else
year = Integer.parseInt(temp);
}
System.out.printf("%15s%25s%5s\n", make, model.toString(), year);
}
scnr.close();
}catch(FileNotFoundException e){
System.out.println(e.getMessage());
}
}
}
My output:
Your Program's Output
Ford Expedition 2003\n
Mazda B-Series 1989\n
Ford Freestar 2003\n
Hyundai Elantra 2001\n
Hyundai Entourage 2008\n
Chevrolet Camaro 2011\n
Chevrolet Monte Carlo 2006\n
Chevrolet Blazer 1996\n
Chevrolet Aveo 2005\n
Chevrolet Corvette 1999\n
Mercedes-Benz E-Class 2006\n
Dodge Avenger 1995\n
Pontiac Grand Prix 1973\n
Mitsubishi Outlander 2011\n
MINI Clubman 2011\n
Suzuki Aerio 2007\n
Dodge Dakota Club 1992\n
Chevrolet Astro 2002\n
Chevrolet Tahoe 1996\n
Mitsubishi Mirage 1994\n
Porsche 944 1991\n
Hyundai Elantra 1994\n
Mercury Grand Marquis 1998\n
Volkswagen Golf 2001\n
Jaguar XJ Series 2005\n
Toyota Echo 2005\n
GMC Safari 2002\n
GMC Sierra 1500 2000\n
Chevrolet Cobalt 2005\n
Jeep Patriot 2008\n
Mazda Navajo 1991\n
Chevrolet Malibu 2001\n
Saab 900 1990\n
Mercury Grand Marquis 1998\n
Hummer H1 2004\n
Subaru Loyale 1993\n
Jeep Wrangler 1999\n
Ford Mustang 1994\n
Austin Mini Cooper S 1963\n
Mercedes-Benz M-Class 1998\n
Jeep Wrangler 2006\n
Honda Civic 1997\n
Plymouth Voyager 1994\n
Ford Club Wagon 1997\n
Audi 5000S 1984\n
Saturn VUE 2003\n
Oldsmobile Achieva 1994\n
Mercedes-Benz G55 AMG 2006\n
Chevrolet Express 3500 1997\n
Lexus ES 1992\n
Cadillac Allante 1992\n
Hyundai Tiburon 1997\n
Pontiac Grand Prix 1965\n
Ford Focus 2000\n
Mitsubishi Chariot 1987\n
Chrysler Prowler 2001\n
Land Rover Discovery 2012\n
Volkswagen Scirocco 1984\n
Ford Bronco 1984\n
Hyundai Accent 1996\n
Volkswagen Routan 2012\n
Volkswagen Golf 2003\n
GMC Terrain 2010\n
Ford F150 2009\n
GMC Sierra 2011\n
Dodge Ram Van 1500 2000\n
Chrysler 300 2009\n
Oldsmobile Achieva 1997\n
Land Rover Discovery 2008\n
Toyota 4Runner 2002\n
Porsche 911 1995\n
Toyota Land Cruiser 2002\n
Land Rover Defender 1994\n
Chevrolet Lumina 1997\n
Audi TT 2002\n
Chrysler Town & Country 2009\n
Nissan Frontier 2000\n
Toyota Tercel 1997\n
Buick Riviera 1997\n
When mine outputs Land Rover is separated and Rover is put with the model, can someone help me fix this, thank you. Keep this in Java.
In: Computer Science
Visit the Microsoft Money website (topic material) and enter the name of a publicly traded company in the "Quote Search" box. When the company information comes up, choose the "Analysis" tab and review the statistics and ratios provided. What does this show you about the company in comparison to industry? Reference specific ratios or statistics in your analysis. When replying to the initial post, change the subject line to the title of the company you researched. Do not post on a company already chosen by a classmate.
In: Accounting
What are the responsibilities/duties of the Board of Directors in acting to protect the shareholders of a publicly traded company?
Why do you think that Directors should have these duties?
Do you believe that shareholders should be allowed to file lawsuits against members of the board if they feel the board member has not done a good job in making the corporation profitable? Why or why not?
In: Finance
Use the information below for ABC Co. to answer the following questions.
Balance Sheet December 31
2005 2004
Assets
Cash $ 20,000 $ 10,000
Accounts receivable 160,000 110,000
Inventories 80,000 50,000
Prepaid Rent 15,000 10,000
Investments 100,000 75,000
Plant assets 210,000 250,000
Accumulated depreciation (65,000) (60,000)
Total $520,000 $445,000
Liabilities and Stockholders' Equity
Accounts payable $ 50,000 $ 40,000
Interest payable 20,000 5,000
Income tax payable 5,000 10,000
Note payable 130,000 140,000
Common stock 155,000 100,000
Retained earnings 160,000 150,000
Total $520,000 $445,000
Income Statement
For the Year Ended December 31, 2005
Sales $800,000
Cost of goods sold 480,000
Gross Profit 320,000
Operating expenses (including Depreciation Expense) 120,000
Interest expense 20,000
Income tax expense 25,000
Total 165,000
Income before Gains and Losses 155,000
Gain on sale of plant assets 5,000
Net income $ 160,000
Additional information:
Accounts payable pertain to the purchase of inventory.
Plant assets were sold for $40,000. The cost of the plant assets was $40,000.
All dividends are cash.
For the year 2005:
1. Cash received/collected from customers is:
2. Purchases for the year is:
3. Cash paid to suppliers is:
4. Depreciation expense is:
5. Cash paid for operating expenses is:
6, Cash paid for interest is:
In: Accounting
what are some challenges that publicly traded companies have encountered in implementing the changes that Sarbanes-Oxley has mandated related to audit committees?
In: Accounting
Trading volume on the New York Stock Exchange is heaviest during the first half hour (early morning) and last half hour (late afternoon) of the trading day. The early morning trading volumes (millions of shares) for 17 days in January and February are shown here (Barron's, January 23, 2006; February 13, 2006; and February 27, 2006)
| Trading Volume (millions of shares) | ||||
| 220 | ||||
| 198 | ||||
| 188 | ||||
| 176 | ||||
| 201 | ||||
| 262 | ||||
| 168 | ||||
| 270 | ||||
| 201 | ||||
| 216 | ||||
| 199 | ||||
| 190 | ||||
| 211 | ||||
| 179 | ||||
| 197 | ||||
| 213 | ||||
| 187 | ||||
a. Compute the mean and standard deviation to use as estimates of the population mean and standard deviation
b. What is the probability that, on a randomly selected day, the early morning trading volume will be less than 195 million shares?
c. What is the probability that, on a randomly selected day, the early morning trading volume will exceed 230 million shares?
d. How many shares would have to be traded for the early morning trading volume on a particular day to be among the busiest 5% of days?
**For B, C, D you show the bell curves in addition to the written work**
In: Statistics and Probability
You want to prepare the balance sheet for Usher, Inc., as of
December 31, 2005. Use the following information. All information
pertains to fiscal 2005 unless otherwise stated.
Retained earnings at December 31, 2004 is $234,000
Sales (all credit sales) are $2.5M
Days to sell inventory is 20
Cash on hand is 1% of sales
All sales are paid 30 days after purchase
Noncurrent assets are $ 1M
Long-term debt to equity ratio is 1
All liabilities, other than long-term debt, are short term
liabilities
20,000 shares outstanding issued at $10 in 2004
No dividends are paid
Gross margin is 40%
Net profit margin is 8%
Assume there are 360 days in the year
In: Accounting