#Wine Magazine
Find the total revenue made by each region from each variety of wine in that region. Output the region, variety, and total revenue.
Take into calculation both region_1 and region_2. Remove the duplicated rows where region, price and variety are exactly the same.
table name: winemag_p1
Solution:
WITH wine_variety AS
(
SELECT CAST(region_1 AS NVARCHAR(50)) AS region, price, variety
FROM winemag_p1
UNION
SELECT CAST(region_2 AS NVARCHAR(50)) AS region, price, variety
FROM winemag_p1
)
SELECT region, variety, SUM(price) AS sum_price
FROM wine_variety
WHERE region IS NOT NULL AND variety IS NOT NULL AND price IS NOT NULL
GROUP BY region, variety
Output (Few records):
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[winemag_p1](
[id] [int] NULL,
[country] [varchar](50) NULL,
[description] [varchar](max) NULL,
[points] [int] NULL,
[price] [float] NULL,
[province] [varchar](50) NULL,
[region_1] [varchar](50) NULL,
[region_2] [varchar](50) NULL,
[variety] [varchar](50) NULL,
[winery] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (69928, N'Italy', N'Oak tonneaux aging renders a rounder, softer and easier-to-drink Brunello. Beautiful layers of aromatic intensity include white mushroom, herbal notes, sweet cedar wood, tobacco, vanilla and cherry. Imported by Tutto Vino.', 87, 90, N'50', N'Tuscany', N'Brunello di Montalcino', N'', N'Sangiovese')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (117156, N'US', N'A bit disappointing on the nose; pickle barrel and onion are supported by moderate spice. This is a dark, extracted wine with dusty tannins and a lean feel. Cherry/berry fruit flavors are shy as they compete with tomato, spice and onion before finishing metallic.', 85, 83, N'22', N'New York', N'The Hamptons, Long Island', N'Long Island', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (60642, N'France', N'Creamy wine, flavored with pears, almonds and crisp acidity. The wine is taut and crisp at the same time. The aftertaste, otherwise fresh, is spoilt by a yeasty bitterness.', 83, 82, N'17', N'France Other', N'Vin Mousseux', N'', N'White Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (114278, N'US', N'A masterpiece from this near perfect vintage. Completely ripe, classic and fresh, with oodles of red cherry and blackcurrant flavors that are generously oaked. Amazingly, the wine is still young and tannic. So beautifully structured, so smooth and polished, firm yet soft, just a gorgeous wine. Hold onto it until at least 2012, if you can.', 93, 97, N'100', N'California', N'Rutherford', N'Napa', N'Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (76671, N'Portugal', N'A splendid Alvarinho, produced in the southern Vinho Verde region, with ripe creaminess as well as shafts of lime juice and grapefruit. It''s ready to drink, while it could age for another year.', 86, 91, N'13', N'Minho', N'', N'', N'Alvarinho')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (81804, N'US', N'There''s something subtlely unripe about this Pinot Noir. It show up in the aroma, with a trace of stewed asparagus. Still, it''s dry and elegant, and the flavors of sour cherry candy and sandalwood make it all right.', 89, 84, N'40', N'California', N'Russian River Valley', N'Sonoma', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (139215, N'Argentina', N'It doesn''t take a great brain to figure out that this is a rocking, beautifully crafted international red wine. Mint, spice and chocolate aromas are dipped in lovely new oak, while the palate is all about bold plum backed by coffee and mocha. Stellar now and shows all signs of a wine that will only get better. Imported by Vias Imports.', 93, 93, N'152', N'Other', N'Rao Negro Valley', N'', N'Malbec')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (88413, N'Italy', N'Known for its panoramic, family-run bed & breakfast, Ca'' du RabajaŠ''s base Barbaresco offers a light, bright appearance with aromas of white chocolate, vanilla, orange zest and wild berry. There''s smoke, licorice and tar in there as well and the wine offers a tart but drying finish.', 93, 90, N'24', N'Piedmont', N'Barbaresco', N'', N'Nebbiolo')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (145698, N'Italy', N'Well oaked and woodsy, with some earthy nuances as well as scents of campfire and rubber. This is a youngster with aggressive tannins and sharp edges. With a bit of time it''ll soften, leaving a top-flight wine with cherry, citrus rind and a hint of sweet oak.', 86, 90, N'63', N'Tuscany', N'Brunello di Montalcino', N'', N'Sangiovese')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (58812, N'Italy', N'A sweet-smelling Soave with simple aromas of peach, pear and honey presented in a very direct and immediate manner. It''s thick and compact on the finish with loads of pineapple-like flavors.', 88, 87, N'18', N'Veneto', N'Soave Classico', N'', N'Garganega')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (102095, N'Italy', N'This is a fresh and light Extra Dry style Prosecco with a luminous appearance and tonic bubbles. The aromas recall citrus, white flower and peach and the bubbly wine would taste great as an aperitivo.', 86, 86, N'18', N'Veneto', N'Conegliano Valdobbiadene Prosecco Superiore', N'', N'Glera')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (16463, N'US', N'This isn''t a very complex Merlot, but it is textbook if you''re looking for soft fruitiness. It has oak-influenced cherry and blackberry flavors, with hints of violets and fruit tea, and is dry and dusty in tannins. Give it more concentration and it would be a star.', 85, 87, N'19', N'California', N'Alexander Valley', N'Sonoma', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (124763, N'France', N'From a small appellation in the north of the Maconnais, producing reds as well as whites, this is initially a mineral, citric wine, which broadens out with toast, fresh acidity and a good weight, with lychee and yellow fruits.', 88, 85, N'', N'Burgundy', N'Macon-Mancey', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (59192, N'US', N'There''s a Floodgate Vineyard in Anderson Valley that produces very nice Pinot Noirs, but this one says it''s from Russian River Valley. This wine is average in quality. It has a fine, silky mouthfeel, with some good cherry flavors, but also a sharp, green touch of mint that''s unlikely to age out.', 87, 85, N'57', N'California', N'Russian River Valley', N'Sonoma', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (133613, N'Italy', N'This Brut Saten offers a creamy mouthfeel accented by cheerful tones of yellow fruit, almond and dried apricot. There is crispness here and the tonic bubbles help keep the palate clean for your next sip.', 83, 90, N'39', N'Lombardy', N'Franciacorta', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (119093, N'US', N'Sharp and penetrating, vertically structured, and just now coming out of its youthful shell, the 2006 is beginning to show its long- term aging potential. Compact blueberry and blackberry fruit comes with a hint of black olive; it''s ripe, quite firm and wrapped into chewy tannins and natural acids, with a lemony finish.', 81, 91, N'33', N'Washington', N'Walla Walla Valley (WA)', N'Columbia Valley', N'Syrah')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (106022, N'Chile', N'Slightly nutty and salinic on the nose, but mostly it''s just neutral. Seems like an early maturing wine, meaning it''s soft in its delivery of melon and apple flavors. Dry and a touch pithy on the finish.', 91, 85, N'12', N'Central Valley', N'', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (95772, N'US', N'Dry, crisp and a bit one-dimensional, this Pinot offers pleasant flavors of cherries, cola, oranges, vanilla and smoke. Seems a bit pricey. Drink now.', 94, 85, N'30', N'California', N'Edna Valley', N'Central Coast', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (128216, N'Italy', N'Paje is a beautiful amphitheater of vines in Barbaresco known for finesse and elegance. This older vintage maintains very good integrity of fruit that is enhanced by layers of black licorice, mineral notes, ash, tobacco and cola. But at the heart of it all is a blast of red cherry. It''s a vertical, intense and streamlined wine that is ready to drink now.', 85, 93, N'190', N'Piedmont', N'Barbaresco', N'', N'Nebbiolo')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (91485, N'US', N'A bit hard in tannins and stinging in acidity, but the lush, ripe flavors make up for it. Offers waves of black and red cherries, cola, licorice and bacon flavors, accented with sweet, smoky oak. Good now, and should develop for a few years.', 87, 91, N'29', N'California', N'San Luis Obispo County', N'Central Coast', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (98801, N'US', N'Made in a lighter, silkier, more accessible style, this is an elegant Pinot Noir that suggests lamb, roast salmon and other upscale dishes. It''s easy to drink, but also complex, with intricately layered flavors of cherries, raspberries, red currants, licorice, sassafras, sweet smoky cedar and Asian spices.', 87, 93, N'40', N'California', N'Sonoma Coast', N'Sonoma', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (30536, N'US', N'This wine made from Muscat Canelli grapes is slightly spritzy and sweet, pungent in apricot fuzz and grass, a melange of tropical goodness from there on out. Mango, kiwi and pineapple fill the medium-weight waves of viscous texture, concluding in a vanilla-tinged, light, fresh finish.', 82, 86, N'25', N'California', N'Napa Valley', N'Napa', N'Moscato')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (131891, N'New Zealand', N'This medium-bodied Riesling combines relatively high alcohol (13%) with ample residual sugar to add even greater richness and mouthfeel. But because of its excellent levels of acidity, it doesn''t come across as particularly sweet or heavy. Tangerine, apple and spice notes linger elegantly on the finish.', 86, 90, N'25', N'Central Otago', N'', N'', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (126576, N'US', N'Rich and round, this offers plenty of concentrated blackberry notes enveloped in warm spices and supple oak. There''s a hint of green tomato leaves throughout, but the lush fruit combined with sturdy grape tannins and high acidity would pair well with fatty short ribs or braised pork.', 93, 87, N'32', N'Virginia', N'Virginia', N'', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (127077, N'Italy', N'This luminous sparkler offers measured aromas of yellow fruit and honey and delivers a broad, wide approach in the mouth. The wine''s texture is creamy and full and there is a spicy point of effervescence on the palate.', 91, 85, N'19', N'Veneto', N'Prosecco di Valdobbiadene', N'', N'Prosecco')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (143029, N'US', N'There are some pretty features to this wine, namely the lovely tannins and rich fruit, but it''s just too soft and sweet. Tastes like blackberry jam, with extra white sugar spinkled on top.', 90, 83, N'45', N'California', N'Paso Robles', N'Central Coast', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (98813, N'US', N'Lovely nose, which runs from violets and cherries right into coffee and sweet chocolate. In the mouth the wine coats the palate with Napa-like intensity, only buttressed with more vivid acidity. It''s both smooth and deep. The aromas are more detailed, interesting and really clean, loaded with dark flavors of soy, coffee, molasses and black cherry liqueur.', 83, 93, N'100', N'Washington', N'Washington', N'Washington Other', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (43172, N'US', N'Tastes sweeter and fruitier than the 2009, which was dry, so if you like orange marmalade, pineapple tart and vanilla cookie sugariness in your Sauvignon Blancs, it''s for you.', 82, 86, N'40', N'California', N'Sonoma County', N'Sonoma', N'Sauvignon Blanc')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (14959, N'France', N'The Jaume family''s business is thriving because of wines like this that faithfully represent their terroirs while offering solid value. This raspberry- and garrigue-scented wine features ample weight framed by supple tannins that firm up on the finish. Drink now 2018.', 97, 89, N'27', N'Rhone Valley', N'Rasteau', N'', N'Rhone-style Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (11285, N'Austria', N'Beautifully pure apple fruit plays on nose and palate. Citrus juice frames the fruit and heightens the freshness even more. If you like a slender, supercrisp style of Riesling, the purity of this will have you hooked.', 91, 93, N'20', N'Kamptal', N'', N'', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (115487, N'US', N'This was a very good vintage for Goldeneye, the best since ''01. The fruit got ripe, offering up a big mouthful of jammy cherry and raspberry flavors accented with sweet oak. The tannin-acid balance is just great. It''s delicious, yet has all kinds of complex edges and nuances.', 84, 93, N'52', N'California', N'Anderson Valley', N'Mendocino/Lake Counties', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (77153, N'US', N'Shows classic varietal flavors of cherries, raspberries and Dr. Pepper, with a sweet edge of smoky oak. Enjoyable now for its forward fruit and silky texture.', 93, 86, N'17', N'California', N'California', N'California Other', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (131535, N'US', N'A very nice, casual Merlot that has layers of complex elegance beyond just the fruit. And what fruit it is, ripe and sweet in cherry pie, raspberry cream, cola and vanilla, with a splash of cassis. Fortunately, there''s enough acidity and tannin for balance.', 90, 88, N'27', N'California', N'Napa Valley', N'Napa', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (89695, N'Argentina', N'Opens with hard, rubbery, leathery aromas. In the mouth, it''s thick and chewy with black fruit but also an herbal edge. There''s depth and plenty of oak here, and it finishes sweet and relatively smooth. Starts rough, improves in the middle, and then finishes fairly well.', 90, 86, N'12', N'Mendoza Province', N'Mendoza', N'', N'Malbec-Syrah')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (44672, N'US', N'A tough, gritty little Pinot Noir, not quite ripe. It smells and tastes of green mint and peppercorns, alongside the cherries and cola, and is rugged in texture.', 87, 85, N'17', N'California', N'Central Coast', N'Central Coast', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (14710, N'France', N'Opulent and ripe, full bodied and rich, this has notes of toast and spice as well as apricot and pear flavors. With its balanced character, it can be consumed now, but it will also age for another year.', 86, 88, N'25', N'Burgundy', N'Pouilly-Fuisse', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (189, N'Spain', N'Coffee grinds, raisin and baked aromas suggest overripeness. This is heavy, broad and a bit clumsy on the palate. Berry and prune flavors are solid but not overly fresh, while the finish is full and raisiny as it improves over time.', 87, 87, N'22', N'Catalonia', N'Montsant', N'', N'Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (28037, N'Austria', N'Gentle red-cherry fruit, soft and pliable tannins and fresh acidity combine to make this a simple and cheerful light red for drinking now.', 85, 83, N'24', N'Burgenland', N'', N'', N'Blaufrankisch')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (70078, N'US', N'Hot, tannic and simple, with cherry jam and currant flavors accompanied by high, tart acidity and chile-pepper alcohol heat. An unbalanced wine.', 85, 81, N'26', N'California', N'Shenandoah Valley (CA)', N'Sierra Foothills', N'Sangiovese')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (150579, N'US', N'Big, fruity wine, with layers of fruit, earth, toast and oak. Spicy cranberry/raspberry fruit leads into toasty, dry tannins. There is a lovely density, buttressed with new oak, but anchored with ripe, firm fruit. Lovely winemaking.', 90, 91, N'26', N'California', N'Russian River Valley', N'Sonoma', N'Zinfandel')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (8438, N'France', N'Big, ripe and fruity, it combines a rich character along with the firmest tannins and dense structure. Acidity adds a touch of freshness, while the structure and full fruit are concentrated and still young. Give this solid, dark wine at least until 2020.', 91, 94, N'294', N'Burgundy', N'Mazis-Chambertin', N'', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (71661, N'US', N'Here''s a good buy in a nice, dry, crisp young Sauvignon Blanc. It has subtle green grass, citrus and vanilla flavors, and finishes clean and zesty.', 85, 85, N'8', N'California', N'California', N'California Other', N'Sauvignon Blanc')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (136867, N'New Zealand', N'This is a pretty, delicately perfumed Pinot Noir, with elegantly intertwined cherry and herb notes. It''s light to medium in body, with a finish that shows just a touch of sinewy intensity. Drink it over the next year or so.', 85, 87, N'18', N'Marlborough', N'', N'', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (25563, N'US', N'Wonderfully rich with lush dark chocolate and espresso notes, this is another lovely, highly drinkable Merlot from Comtesse Therese. There''s a good amount of charred oak, but it''s integrated seamlessly with concentrated black plum and berry flavors. The finish is long, and accented by pleasant astringency of walnut skins and tobacco.', 93, 87, N'18', N'New York', N'North Fork of Long Island', N'Long Island', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (23710, N'Argentina', N'Foxy cherry and cough drop aromas are not convincing. Feels astringent and tastes tart, with sharp but candied cherry, faux oak and milk chocolate flavors. Blends sour notes with sweet oak, all to little avail.', 91, 82, N'25', N'Mendoza Province', N'Mendoza', N'', N'Malbec')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (124140, N'Italy', N'This is a simple and cheerful Nero d''Avola that would pair well with white meats such as roast chicken or pork. Aromas here include blueberry, forest berry and there''s a touch of bitter almond on the close.', 93, 86, N'12', N'Sicily & Sardinia', N'Sicilia', N'', N'Nero d''Avola')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (138408, N'US', N'Forward and lush, with a beautiful structure, this dry, balanced wine has cherry, cassis, wintergreen and oak flavors that finish in a swirl of complexity. This fine wine defines the elegance and femininity of a great Rutherford Cab, and should age well through 2012.', 86, 93, N'85', N'California', N'Rutherford', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (94438, N'Germany', N'A lush and enormously fruity auslese, this offering features layers of appealingly ripe fruit, ranging from honeyed peaches to tropically luscious mangoes. If it''s a bit fat and lacks a touch of zip, it makes up for it with sheer deliciousness.', 90, 91, N'27', N'Mosel-Saar-Ruwer', N'', N'', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (129416, N'Spain', N'A bit murky and damp on the nose, with brandied fruit and raisin aromas. The palate is solidly formed, with basic raspberry flavors but not much follow through as the finish shows buttery, soft flavors. Inoffensive but more generic than individual.', 85, 85, N'22', N'Northern Spain', N'Ribera del Duero', N'', N'Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (57896, N'US', N'Dark and heavy, almost Rhone-like, with significant tannins that interfere with palate pleasure. There''s a deep core of black cherries and lots of oak. Could develop.', 87, 87, N'48', N'California', N'Sta. Rita Hills', N'Central Coast', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (110923, N'France', N'A full, balanced wine with layers of grapefruit and a pure citrus streak. Secondary flavors of almonds and toast add complexity. This is not profound, but it is eminently enjoyable.', 85, 89, N'50', N'Champagne', N'Champagne', N'', N'Champagne Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (72945, N'Italy', N'Here''s a lovely sparkling wine that offers a floral fragrance of white flowers and tropical fruit. The palate delivers apple, white peach and a hint of almond. It has a creamy texture and a clean, crisp finish. A classic Franciacorta.', 89, 91, N'29', N'Lombardy', N'Franciacorta', N'', N'Sparkling Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (146614, N'US', N'Starts out with pleasant notes of supple fruit, but there''s too much oak showing at the moment, and the fruit quickly gets buried. Some bitter tannins conclude; give this one extra airtime to soften it up.', 91, 87, N'23', N'Washington', N'Columbia Valley (WA)', N'Columbia Valley', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (133764, N'Germany', N'Despite notes of honey and baked apple, this is an almost dry wine, boasting plenty of weight in the mouth. Orangey flavors pick up hints of peach and dried spices, turning stony on the finish.', 87, 89, N'20', N'Pfalz', N'', N'', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (59890, N'US', N'Tough in tannins, austerely dry and thin in fruit, this Cab lacks voluptuousness. You''ll find cooked cherry-berry flavors that are swamped by alcohol and tannins.', 89, 82, N'46', N'California', N'Paso Robles', N'Central Coast', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (50936, N'US', N'Tastes like ripeness ran away with this wine. The blackberry flavors are explosive, making it taste like jam, while the oak is very strong, almost overpowering in smoky char. Pretty good, but overworked. Drink soon.', 82, 88, N'45', N'California', N'Alexander Valley', N'Sonoma', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (66901, N'US', N'For those who love the austere, steel and stone flavors of bone-dry Riesling, this will be a welcome discovery. It has plenty of power, citrus rind flavors of fruit and skin, a persistent minerality and a clean, fresh finish.', 88, 89, N'21', N'Oregon', N'Willamette Valley', N'Willamette Valley', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (119883, N'Chile', N'Stalky aromas suggest corn and hayfield more than crisp fruit, and while the palate is lively and acidic, it''s also kind of sour and lemony. Finishes with green apple and citrus. Jumpy and scouring.', 89, 83, N'9', N'Curica Valley', N'', N'', N'Sauvignon Blanc')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (132533, N'US', N'Tastes immature now, with the toasty oak not yet integrated, and the tannins also stick out in all their sticky glory. The fruit is exceptionally ripe, suggesting grilled blackberries and black currants. The suggestion is ageability. Better sometime after mid-2010.', 83, 90, N'75', N'California', N'Napa Valley', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (115133, N'US', N'This is off-dry, roughly 2% residual sugar, and the sweetness is quite evident. It''s rather fleshy for a Gewarzt, with honeysuckle, melon and peach fruit. There is a nice spiciness to the aroma as well, and it carries into the midpalate, lending a welcome streak of licorice.', 90, 87, N'9', N'Washington', N'Columbia Valley (WA)', N'Columbia Valley', N'Gewarztraminer')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (65643, N'Portugal', N'A fine, elegant wood-aged wine. It has ripe fruits, sweet peach, apricot, mango, while the vanilla of toast lifts all the flavors, adding spicy smoothness. Acidity comes from fresh lime. It could do with some aging, maybe 2’3 years.', 87, 89, N'19', N'Bucelas', N'', N'', N'Arinto')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (39970, N'Spain', N'Quite an oaky wine, with aromas of BBQ, hickory, roasted plum and spice. The body is full but scratchy, with additional oak manifesting itself in the form of baked, rooty, vanilla flavors that override the wine''s simple but quiet fruit content. Finishes dark and toasty, with coffee, mocha and vanilla flavors.', 89, 85, N'18', N'Northern Spain', N'Carinena', N'', N'Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (111673, N'US', N'A new bottling from the winery, made from vines grown 2,000 feet up the mountain that were planted only in 2001. It''s far too immature to drink now or anytime soon. The tannins are thick and on lockdown, the blackberry, cassis and cherry fruit all primary and not yet integrated with the oak. But these parts are high-quality and need time to mesh and develop. Best after 2010 through 2016 and beyond.', 85, 93, N'70', N'California', N'Napa', N'', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (43682, N'US', N'Made in the modern style of soft, sweet opulence, this is insanely rich, with notes of cherry marmalade, red currant, milk chocolate and sweet cedar flavors that continue onto the long, smooth finish. It''s a blend of the traditional red Bordeaux varieties, and while it was aged in 100% new French oak, it''s not too oaky. Drink over the next six years for its youthful beauty.', 93, 93, N'67', N'California', N'Napa Valley', N'Napa', N'Bordeaux-style Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (124341, N'US', N'This is a heavy, dense and not very rewarding Pinot Noir at this time. It''s soft and full-bodied and very ripe in cherries, blackberries and cola flavors. Could age to mellow sweetness, but it''s a gamble.', 93, 86, N'44', N'California', N'Chalone', N'Central Coast', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (83955, N'France', N'A solid and very drinkable wine, the forward black fruit elements are accented by hints of fudge and sweet spice on the finish Drink now.', 86, 84, N'8', N'Languedoc-Roussillon', N'Pays d''Oc', N'', N'Merlot')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (811, N'Greece', N'Crisp acidity and a gorgeous, aromatic nose lead on this elegant white. Though mineral-driven, it offers generous white peach and grapefruit flavors that will pair well with fuller-bodied fish. Impressive and versatile.', 84, 90, N'20', N'Santorini', N'', N'', N'Assyrtiko')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (81207, N'Chile', N'This smells horsy, feral and herbal. Dry, rock-hard tannins make it feel rugged in the mouth, and it''s already five years old.', 90, 85, N'80', N'Cachapoal Valley', N'', N'', N'Cabernet Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (131578, N'France', N'The extra amount of clay in the soil of this vineyard lends weight, richness and roundness. At the same time, it has fresh lime, an open character and a soft structure.', 85, 88, N'42', N'Burgundy', N'Chablis', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (31628, N'Argentina', N'This warm-weather Viognier is fleshy and chunky on the bouquet, with generic white-fruit aromas that suggest gardenias. A plump palate is low on acid and heavy in weight; flavors of melon and green herbs finish soft and could turn flabby in a short time.', 88, 84, N'12', N'Mendoza Province', N'Uco Valley', N'', N'Viognier')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (143226, N'US', N'Offers lush, intricate flavors of blackberries, cassis, roasted coffeebean, sweet milk chocolate and toasty oak in a soft, gentle wine that has complexity and interest. Not an ager, but a real beauty.', 84, 91, N'35', N'California', N'Alexander Valley', N'Sonoma', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (47010, N'Australia', N'Ripe indeed, with confectioner''s sugar, vanilla ice cream and honey aromas that lead to a light-to-medium-bodied palate with some disjointed oak notes and a slightly oily texture. Short but pleasant finish of figs and candied lemons. Drink up.', 87, 84, N'11', N'Australia Other', N'South Eastern Australia', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (30763, N'France', N'Tropical fruit aromas lead to a peach- and apricot-flavored palate. It shows old-vine concentration, spice from having aged in wood and a generous, velvet-like texture that is balanced by a fine shot of lemony acidity. Age this for 4’5 years.', 84, 92, N'62', N'Burgundy', N'Meursault', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (103920, N'Italy', N'Here''s an oak-driven Sauvignon Blanc from the 2004 vintage with a thick layer of toast, nut and campfire that play a leading role and leave little room for the wine''s natural fruit and floral tones. Those carpentry notes also dominate the mouthfeel and add a piquant touch of exotic spice on the close. That said, this white wine has held very well over the years.', 91, 87, N'55', N'Central Italy', N'Forla‚', N'', N'Sauvignon Blanc')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (70740, N'Spain', N'CUNE is a throwback bodega whose wines won''t appeal to followers of the new wave. And since I consider myself a backer of the modern style, I found this wine too obtuse, funky and borderline dirty to rate higher. It''s full of mossy, stewy flavors and the feel is heavy. Traditionalist, however, may find it worthy of greater praise.', 84, 84, N'60', N'Northern Spain', N'Rioja', N'', N'Tempranillo')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (37483, N'France', N'Produced by the winemaking team of Chateau Giscours in Margaux, this is impressive for a simple Bordeaux. It has weight, rich blackberry fruits, structure and concentration. It could even age.', 92, 89, N'', N'Bordeaux', N'Bordeaux', N'', N'Bordeaux-style Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (137840, N'Italy', N'Typical of this hot vintage, La Fiammenga is already quite mature. The fruit is on the plummy side, it has the added complexity of licorice and road tar. On the palate, it is soft and rich but it does need a touch of acid to liven it up. Imported by Sapori Italiani Inc.', 89, 87, N'28', N'Piedmont', N'Barbaresco', N'', N'Nebbiolo')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (117908, N'US', N'The estate bottling is 100% Semillon and tastes a bit riper and more peachy than the Columbia Valley bottling, though perhaps less nuanced. Barrel fermented in both new and second year French oak, it adds honeysuckle, sweet apple and a hint of mint to the sweet fruit.', 87, 91, N'20', N'Washington', N'Walla Walla Valley (WA)', N'Columbia Valley', N'Semillon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (141797, N'Chile', N'Not the most Syrah-like wine you''re likely to encounter, but as a generic red it''s juicy, fruity and tasty. The balance is fine and the fruit weighs in solid and proper. Complete but lacking individuality.', 91, 85, N'15', N'Maipo Valley', N'', N'', N'Syrah')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (129536, N'France', N'This is all tannin, bitter chocolate and a dense texture. It seems to be drying out as the fruit goes, while there are few signs of softening. It suffers from the heat of 2003.', 85, 82, N'', N'Bordeaux', N'Premieres Cotes de Bordeaux', N'', N'Bordeaux-style Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (4180, N'US', N'Of all the 2012 releases from Mannina, this is the most dense, dark and substantial. Cassis and black cherry fruit is set against a stiff streak of char and coffee, backed with firm, ripe tannins. The length and balance are just right for ripe fruit from young vines.', 82, 90, N'30', N'Washington', N'Walla Walla Valley (WA)', N'Columbia Valley', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (137681, N'Portugal', N'A success in the sweeter Vinho Verde category. There is pleasant softness, flavors of green berries, grapefruit with sugar and freshness.', 90, 84, N'6', N'Vinho Verde', N'', N'', N'Portuguese White')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (107120, N'Germany', N'This wonderful auslese offers volume and richness without weight“it''s a sort of fluffy custard in texture, loaded with funky, leesy notes on the nose but also with passion fruit, green apple and pineapple notes on the palate. Yes, it''s sweet, but the acids provide beautiful balance on the finish. Drink now’2025.', 84, 92, N'58', N'Mosel', N'', N'', N'Riesling')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (150557, N'Italy', N'The modest cherry, dark berry and black tea notes of this light wine show tell-tale orange-peel notes of decline. This feels just too thin and tired at an early age.', 92, 81, N'15', N'Tuscany', N'Chianti Classico', N'', N'Sangiovese')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (14408, N'Italy', N'With its thick density and slightly off-dry flavors of raisin, cassis, honey and liquid smoke, this would pair with hearty country pate or meat terrines. Its alcohol, mild tannins and fresh-fruit finish would also work with those fatty foods.', 81, 88, N'22', N'Veneto', N'Valpolicella Classico Superiore Ripasso', N'', N'Corvina, Rondinella, Molinara')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (8670, N'Turkey', N'A nose of strawberry and mint with a whiff of petrol sets the scene for flavors of cassis, cherry preserves, peach and eucalyptus that never quite coalesce. Soft tannins drop off immediately after a burst of white peach at the finish.', 88, 86, N'15', N'Turkey', N'', N'', N'Kuntra')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (146870, N'South Africa', N'A fairly big wine, with big tannins and high acidity, that lets its flavors do the talking. Lush purple fruit and coffee is streaked with lemon and mineral. A bit tart on the finish, but with food this is enjoyable for its swagger.', 86, 87, N'20', N'South Africa', N'', N'', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (59388, N'New Zealand', N'This attractively priced Pinot Noir combines fruit from Nelson and Marlborough to create a fresh, snappy blend of plum and black cherry fruit. Some slightly briary-herbal notes and silky tannins add interest, smoothed out by hints of brown sugar and baking spices. Drink now’2012.', 87, 88, N'20', N'New Zealand', N'', N'', N'Pinot Noir')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (6168, N'Moldova', N'This 100% Feteasca Neagra has aromas of fresh strawberry and red plum. It is soft on entry into the mouth and has flavors of dried cherries, cloves and prunes.', 88, 88, N'12', N'Moldova', N'', N'', N'Feteasca Neagra')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (128257, N'Bulgaria', N'This refreshing Chardonnay“with aromas of grapefruit and lemon and flavors of zesty grapefruit and lemon zest“is anchored by a weight that gives it balance. Overall, the wine finds a great middle ground and is food friendly.', 88, 84, N'8', N'Bulgaria', N'', N'', N'Chardonnay')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (116551, N'US', N'Tasted in October, 2007, the wine was mute, offering little aromatically except for teasing notes of blackberries and oak. That shyness extended to the taste, where strong, hard tannins provide an almost impenetrable coat of armor to what''s inside. But right down the middle of the palate is a deep, intensely powerful stream of perfectly ripened cassis that''s all the proof you need of ageability. This is a magnificently structured young wine, reminiscent of a fine young Pauillac. Best after 2012, and should have another decade after that, at least.', 84, 97, N'200', N'California', N'Napa Valley', N'Napa', N'Bordeaux-style Red Blend')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (116564, N'US', N'It''s impossible for a Cabernet to be richer, more opulent or more hedonistically stunning on opening than this beauty from veteran Phelps. Admittedly, there are significant tannins. But the wine delivers a broadside of the sweetest, ripest cassis fruit imaginable, along with richly toasted oak. It''s the kind of Cab that will dazzle even an amateur. Absolutely gorgeous now, with immaculate elegance. About the only criticism you can offer is that the structure is a bit obvious, and ageability may be limited.', 97, 95, N'200', N'California', N'Oakville', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (74057, N'US', N'The former basketball star''s initial release immediately establishes itself among the elite Cabernets of Napa Valley. Made from mountain vineyards on Atlas Peak and benches in the Rutherford appellation, it combines intensity with elegance. Bursts with upfront, delicious blackberry, creme de cassis and dark chocolate flavors that are wildly sweet on the midpalate, but then finish thoroughly dry. Structure comes by way of a tangy minerality and finely laced tannins. This is one of those wines that is softly decadent from start to finish, although it''s probably not one to hold much beyond six years.', 95, 97, N'625', N'California', N'Napa Valley', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (83298, N'US', N'Made in the Lokoya style, which is darkly colored, full bodied, tannic and dense in mountain fruit. A spicy oak tone joins with massive blackberry, cassis and violet flavors to make this wine delicious from the start. It''s very tannic and needs a great deal of time. Begin to enjoy this wine in 2016, and it should go far longer than that.', 97, 94, N'350', N'California', N'Diamond Mountain District', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (135895, N'US', N'A disappointing wine. Tastes frankly unripe, with a vegetal undertow to the blackberries and cherries. The thinness of fruit accentuates the alcohol which, although only 14.6%, comes through as hot. The grapes came from the cool Coombsville area, and the wine is 100% Cabernet.', 94, 84, N'225', N'California', N'Napa Valley', N'Napa', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (118377, N'Argentina', N'Granular, raisiny and heavy on the nose, with jammy blackberry aromas. The palate then hits with a thud; it''s chunky and low in acidity, which yields a thick flavor set of prune and coffee. Better once it breathes, but it''s still a bit too sticky and syrupy for our liking.', 84, 85, N'20', N'Mendoza Province', N'Mendoza', N'', N'Malbec')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (119041, N'Argentina', N'The ?oak‰Û� in the name is appropriate because this one is draped in unctuous, heavy, burnt aromas. The nose is a cloud of coconut, char and woody blackberry, while the syrupy palate is all sweet black plum, carob, mint and resin. Quite oaky and thick for a value-priced wine.', 85, 83, N'12', N'Other', N'San Juan', N'', N'Malbec')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (132683, N'Argentina', N'Jammy red-fruit aromas mixed with buttery oak make for a simple, sappy nose. There''s more butter on the palate in addition to solid blackberry flavors. It finishes round but short, with yet another wave of barrel. A very good wine but not one that wows.', 83, 87, N'18', N'Mendoza Province', N'Luja?n de Cuyo', N'', N'Malbec')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (44070, N'Argentina', N'Rubbery and warm on the nose, with earthy plum and blackberry aromas. The palate is full and bouncy, with appropriate plum, berry and cassis flavors. Nice for standard New World Cab, with fig, chocolate and no buttery, sloppy oak.', 87, 86, N'10', N'Mendoza Province', N'Mendoza', N'', N'Cabernet Sauvignon')
GO
INSERT [dbo].[winemag_p1] ([id], [country], [description], [points], [price], [province], [region_1], [region_2], [variety], [winery]) VALUES (129117, N'Argentina', N'Colorful but low in pulse, with jammy, pasty aromas sitting in front of a bulky, one-dimensional palate that offers standard blackberry fruit and mildly herbal side flavors. Has just enough acidity to keep it pumping, but as a whole it comes across a little too heavy and jammy compared to previous years.', 86, 85, N'25', N'Other', N'Rao Negro Valley', N'', N'Malbec')
GO